Variable in Range statement

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

 

[Tim Williams]

set myrange = range("C26:Y" & x)


tim

 

[Mike]

Thanks, Tim

-----Original Message-----
set myrange = range("C26:Y" & x)


tim





.