End of Excel data throurh VBA

Closed
Ket - Jun 2, 2009 at 07:27 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jun 3, 2009 at 04:00 AM
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.

1 reply

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 3, 2009 at 04:00 AM
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
2