Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Range error
I'd appreciate some insight about setting ranges with Excel 2003 VBA. In particular, why does THIS work Dim fromRange as Range .... Worksheets("AAdata").Activate Set fromRange = Range(Cells(2, 4), Cells(2, 11)) And THIS give a Run-time "Application-defined or object-defined error", #1004, error: Dim fromRange as Range .... Set fromRange = Worksheets("AAdata").Range(Cells(2, 4), Cells(2, 11)) TIA R. Spleen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Range.Select error and screen maximizing error in Workbook_Open() | Excel Programming | |||
Range.Select error and screen maximizing error in Workbook_Open() | Excel Programming |