Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax Error In Date | Excel Discussion (Misc queries) | |||
Syntax error | Excel Discussion (Misc queries) | |||
syntax error - help | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
need help with simple syntax error | Excel Programming |