Range.

[Nigel Martin]

How do you highlight a dynamic range in VBA I guess it's something along the lines of Selection.End(xlDown).Select - but as a range.

 

[AJ]

Like this?...
Range(Selection, Selection.End(xlDown)).Select

 

[Nigel Martin]

That works perfectly but I also need it to select to the right as well ? i.e all the data on the worksheet.

 

[AJ]

I just recorded this...

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

Or to do it in one line, using the SpecialCells method:

Range(Selection, Cells.SpecialCells(xlLastCell)).Select

 

[Nigel Martin]

Many thanks AJ - it works perfectly.