Hi James, I'm selecting the first column of a range called "Test" in the code
below:

Sub SelFirstCol()
'Select first column of defined range
Range("Test").Columns(1).Select
End Sub


"James Cornthwaite" wrote:

does anybody know how to select the entire first column of a defined range
object.

rng.columns(2).select doesnt seemt to work

Thanks
James