Variable in Range statement

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi. I have the variable "x" which returns the row number
of the activecell. I would like to set "myrange" to be
equal to the range C26 to Y of the active row. Can
someone show me how to write the range statement using
the variable x?

myrange = range(C26:Y .... what do I put here?)

Thanks,
Mike.
 
Back
Top