CTRL, Shift & End Macro question

[JonRowland]

Trying to emulate the CTRL, Shift & End keystroke as a macro but can't quite get the code right.

I am using the following

Range("B3").End(xlDown).Select

However this doesn't select all the cells within the column from B3.

Anyone help?

Thanks

Jon

 

[Domski]

Try this:

Range("B3", Range("B3").End(xlDown)).Select

 

[jindon]

hi

try

Range("b3",Range("b3").end(xlDown))


jindon

 

[JonRowland]

Bingo, thanks guys

Jon