Select used range

JAYLO · Apr 9th, 2002, 09:02 AM

How can I automatically select the used range of a column?

Mark O'Brien · Apr 9th, 2002, 09:26 AM

Here's an example to select the usedrange of column A (or columns(1)):



  Dim oRange As Range

  

  Set oRange = Sheets("Sheet1").UsedRange

  oRange.Columns(1).Select

HTH

Al Chara · Apr 9th, 2002, 11:00 AM

You can also use the following to select the usedrange of column A:

Intersect(ActiveSheet.UsedRange, Columns("a")).Select

(Just to show how to use the Intersect method)

Apr 9th, 2002, 09:26 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Here's an example to select the usedrange of column A (or columns(1)): Dim oRange As Range Set oRange = Sheets("Sheet1").UsedRange oRange.Columns(1).Select HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 9th, 2002, 11:00 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can also use the following to select the usedrange of column A: Intersect(ActiveSheet.UsedRange, Columns("a")).Select (Just to show how to use the Intersect method) __________________ Kind regards, Al Chara

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

Apr 9th, 2002, 09:02 AM	#1
JAYLO Board Regular Join Date: Apr 2002 Posts: 210	How can I automatically select the used range of a column?