View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Variable in Range statement

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.