Where is my syntax error?
I believe I've figured it out ... Apparently, you need to
type a space before and after the "&" symbol. My new
statement is:
Set myrange = Worksheets("Practice").Range("c" & lastRow
& ":y" & 39)
Mike.
-----Original Message-----
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.
.
|