The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi
In my macro, I'm selecting a Range that Starts from A2:AK***
Normally I would record the macro using
The problem is that not all of 'Column M' is populated and if it is the last cell thats empty, then it will stop there. There are a couple of other columns which also have some empty cells.
Is there anyway of having a formula that will allow me to scroll down to the last data of Column A (Data is variable) but then have it hardpaste across to Column AK so that the entire data in the range is selected??
Thanks in advance
In my macro, I'm selecting a Range that Starts from A2:AK***
Normally I would record the macro using
Code:
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
The problem is that not all of 'Column M' is populated and if it is the last cell thats empty, then it will stop there. There are a couple of other columns which also have some empty cells.
Is there anyway of having a formula that will allow me to scroll down to the last data of Column A (Data is variable) but then have it hardpaste across to Column AK so that the entire data in the range is selected??
Thanks in advance