VBA xltoright, end xldown

[Mr2017]

Hi

I need to select a range of data from row 5 to the end of the number of columns, then the end of the number of rows.

I've used this, but get a Compile error.

Range("A1", Range("A1").End(xlToRight).End(xlDown).Select

Can someone please point out where I've gone wrong?

Thanks in advance

 

[Mr2017]

Actually, I found this, which does the trick:

(I'm going from cell B5 in the actual data).

Range("b5", Range("b5").End(xlDown).End(xlToRight)).Select

 

[Fluff]

You are missing a closing bracket

Range("A1", Range("A1").End(xlToRight).End(xlDown)).Select