Row Selection

[The_Rock]

Hi
In my macro, I'm selecting a Range that Starts from A2:AK***

Normally I would record the macro using

 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

 

[DonkeyOte]

can you not use UsedRange property ?

eg

Dim rng as range
Set rng = ActiveSheet.UsedRange
rng.Select

 

[The_Rock]

Unfortunately, I'm not too familar with VBA codings.
Most of my macro's are done via the record button with a few manual tweaks here and there.

I'll give the below a try.

 

[Mike Blackman]

Hi,

How about;

Range("A2:AK" & Range("A" & Rows.count).End(xlUp).Row + 1).Select

 

[The_Rock]

Mikey, thanks for that. Worked like a charm!!