plz experts..spare some time on my problem.
looking forward for your help.
On Friday, July 5, 2013 5:25:27 PM UTC+5:30, SG wrote:
hi Experts,
I'm in a great problem as i'm beginner in macros.I have created a template
in which the data would be extracted on basis on 3 criterias.However, by
Hi,
The following will select the last data column, Row 1:
Cells(1, Columns.Count).End(xlToLeft).Select
The following assigns the last data column number to the variable 'A'
A = Cells(1, Columns.Count).End(xlToLeft).Column
The following will select the last data row, Col A: