View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Where is my syntax error?

Can anyone tell me what is wrong with my syntax below? I
have a variable called "lastrow" and I want to set
myrange to be equal to C through Y of the last row. For
instance, if the last row is 39, I would want myrange =
range("C39:Y39"). My code follows:

Set myrange = Worksheets("Practice").Range
("c"&lastrow&":y"&lastrow)

Thanks,
Mike.