Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Syntax
Hi. Appreciate if anyone can point out the error in the follwing statements
which work in the immediate window but keep turning up runtime error 1004 on the second statement when I run the program: Sheets("Cycle Data").Activate Range("CR3:CX3").Resize(Range("CR2")).Select Note that cell CR2 contains an integer. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative range syntax | Excel Programming | |||
syntax - range name as a variable | Excel Programming | |||
Syntax help with range | Excel Programming | |||
Syntax to Set variable range | Excel Programming | |||
Range syntax | Excel Programming |