Mike,
You are correct. VBA uses the '&' character for several things,
including concatenating string, declaring variable types, and
declaring numeric bases. You need the spaces to let VBA know
what you are actually doing.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mike" wrote in message
...
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.
.