Select Range using variables
Define "variable number of columns to the left". Back to Column A or ??? If
Column A then...
dim rngTo Select as range
dim wks as worksheet
set wks = activesheet
set rngtoSelect = wks.range(activecell, .cells(activecell.row + 16, "A"))
rngtoselect.select
--
HTH...
Jim Thomlinson
"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.
|