View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default VBA range selection question

This is one letter shorter than your first suggestion.

Thanks


Gord

On Sun, 8 May 2011 11:30:29 -0700 (PDT), joeu2004 wrote:

On May 8, 11:27*am, joeu2004 wrote:
One way:
GetColNum = Range(myColumn & 1).Column


Another way:

GetColNum = Cells(1, myColumn).Column