View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paul Mathews Paul Mathews is offline
external usenet poster
 
Posts: 84
Default selecting a column

Um, one other thing, you'll need to select the sheet the desired range
resides in before you attempt to select the column.

Sub SelFirstCol()
'Select first column of defined range
Sheets("BlahBlah").select
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