Select used range

[JAYLO]

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

 

[Mark O'Brien]

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

<pre>
Dim oRange As Range

Set oRange = Sheets("Sheet1").UsedRange
oRange.Columns(1).Select</pre>

HTH

 

[Al Chara]

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)