Range.

Nigel Martin · Apr 30th, 2002, 06:26 AM

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 · Apr 30th, 2002, 06:40 AM

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

Nigel Martin · Apr 30th, 2002, 06:59 AM

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

AJ · Apr 30th, 2002, 08:15 AM

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 · Apr 30th, 2002, 08:32 AM

Many thanks AJ - it works perfectly.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 06:26 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	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.

Apr 30th, 2002, 06:40 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Like this?... Range(Selection, Selection.End(xlDown)).Select

Apr 30th, 2002, 06:59 AM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	That works perfectly but I also need it to select to the right as well ? i.e all the data on the worksheet.

Apr 30th, 2002, 08:15 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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

Apr 30th, 2002, 08:32 AM	#5
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Many thanks AJ - it works perfectly.