Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbookwith 84 sheets. When I try to select (or activate) a range I
get runtime error 1004. In debugging the file, I find I can print the individual cells (in a different workbook, wkFix), but cannot select the range. Here's the relevant code: With wkState.Sheets("NDX1") For j = iCol1 To iCol2 wkFix.Sheets(1).Cells(j - iCol1 + 1, 13) = .Cells(jRow, j) Next j ' I have no problem in printing Range(.Cells(jRow, iCol1), .Cells(jRow, iCol2)).Select 'But the above line gives me the runtime error End With Can this have anything to do with the number of spreadsheets? I'm running VBA 6.3, Excel 2003 SP1 with XP Pro TIA, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime Error 1004 Select method of Range class Failed | Excel Programming | |||
Set worksheet range runtime error 1004 | Excel Programming | |||
Runtime Error 1004 - Method Range of '_Global failed' | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming |