Where is my syntax error?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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.
 
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.
 
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
 
Back
Top