$$Excel-Macros$$ Re: Macro Problem...plzzz help

2013-07-05 Thread SG
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

$$Excel-Macros$$ Re: Macro Problem

2009-04-28 Thread Dave Bonallack
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: