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.
|