End of Excel data throurh VBA [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!