Thread: VBA range selection question
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default VBA range selection question
On May 8, 11:27*am, joeu2004 wrote:
One way:
GetColNum = Range(myColumn & 1).Column

Another way:

GetColNum = Cells(1, myColumn).Column
Reply With QuoteReply With Quote