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 response

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