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. |
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. . |
Where is my syntax error?
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. . |
All times are GMT +1. The time now is 08:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com