Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In a new wb and ws:
In the Immediate Window I enter: range("A1:A10").Name = "TestRange" ? Range("TestRange").address $A$1:$A$10 <<< results of above line Range("TestRange").Resize(5,3) As Range << When I enter this I get Compile error: Expected: End of Statement Why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If-Then-Else resulting in DIV/0 error | Excel Programming | |||
If-Then-Else resulting in DIV/0 error | Excel Programming | |||
If-Then-Else resulting in DIV/0 error | Excel Programming | |||
If-Then-Else resulting in DIV/0 error | Excel Programming | |||
If-Then-Else resulting in DIV/0 error | Excel Programming |