Search : in
By :

End of Excel data throurh VBA

Last answer on Jun 3, 2009 9:00:41 am BST Ket, on Jun 2, 2009 12:27:49 pm BST 
 Report this message to moderators

Hello,
Is there any method to find a particular value in the excel through VBA.

Alternatively: how can i get the colunm and row of the cell where the last entry is being made in the excel.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « End of Excel data throurh VBA » in :
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......
Download Data Manager for Excel ShowHave you already thought that your Excel worksheet can be transformed into a true database? Now, it is possible thanks to Data Manager for Excel. Data Manager for Excel is an add-in for Microsoft Excel allowing to transform the worksheets into...
Download Excel-MySQL converter ShowHenceforth with Excel-MySQL Converter, it is not necessary to be a developer to be able to convert Microsoft Excel data into MySQL database or vice versa. This program allows you to convert quickly your data without using other material. Depending...
Download XlsToOra ShowDescription The application is designed by WithData Software. XlsToOra is a tool that allows you to import you Excel data to Oracle database. Simple and easy to use, the application has been awarded from certain popular places. The application...
Introduction - Databases ShowWhat is a database? A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...

1

 Excelguru, on Jun 3, 2009 9:00:41 am BST
  • +1

Hi

Is there any method to find a particular value in the excel through VBA. - Record one macro
how can i get the colunm and row of the cell where the last entry is being made in the excel. - use usedrange.columns.count and usedrange.rows.count Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

Reply to Excelguru