James

In the code below the column selected is E. The 2nd column in the range
D1:G100

Sub SelectColumnInRange()
Dim rng As Range
Set rng = Range("D1:G100")
rng.Columns(2).Select
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"James Cornthwaite" wrote in message
...
If I have a range object passed to a function, eg, rng, does anybody know
how to just select column A from this larger range, rng

Is it some sort of union i have to do.

Many thanks
james