View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Monica Monica is offline
external usenet poster
 
Posts: 37
Default How do I create this range?

I am trying to set a range in vba, but am having trouble figuring out how to
code it.
I know the proper syntax is normally this:
MyRange = Worksheets(ActSheet).Range("C5:C50")

My problem is that I won't have the LETTER (like C) of the column, only the
number, like instead of column "C" I would have a number 3. So basically,
how can I replace the ("C5:C50") portion with integer type variables?

Thanks in advance