Nancy, for the sample below, the last column is column G, but what cell address would you expect for the second part of your question for this sample data?Hi
What is the quickest way using VBA, to find the last column used on a
sheet so I know the column number and also the address of this cell.
Thanks,
Nancy
Mr Excel.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 1 | a | b | c | c | c | c | |||
2 | 2 | |||||||||
3 | 3 | |||||||||
4 | 4 | c | ||||||||
5 | 5 | |||||||||
6 | 6 | |||||||||
7 | 7 | |||||||||
8 | ||||||||||
Sheet1 |
I am not sure that there are any spare medals lying around, but I'll shout you an imaginary beer.I use this method:
http://www.beyondtechnology.com/geeks012.shtml
My 100th post!!!! Can I have a medal now please?