View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
StephanieH StephanieH is offline
external usenet poster
 
Posts: 95
Default Select Range using variables

Nevermind. I answered my own question.

ActiveCell.Range(Cells(1, 1), Cells(16, MyMonths)).Select



"StephanieH" wrote:

I need to select a range from the active cell 16 rows down and a variable
number of columns to the left. I've named my variable "MyMonths", but I'm
not sure how to incorporate it into a range address.