| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 2029. How do I fix this error
c.Offset(0, 2) = Evaluate("=SUMPRODUCT(--('BO Download'!$B$" & DIregion_sRow
& ":$B$" & BOReport_lastRow & "=" & c.Value & "),--('BO Download'!$F$" & DIregion_sRow & ":$F$" & BOReport_lastRow & "=" & c.Offset(0, 1) & ")," & _ "--('BO Download'!$H$" & DIregion_sRow & ":$H$" & BOReport_lastRow & "=""Selected""))") c.Offset(0, 2)=Error 2029 whe c.Value="INDIANAPOLIS IN" c.Offset(0, 1)="ZAYO BANDWIDTH" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem sorting by date after 2029 on Excel 2003 | Excel Discussion (Misc queries) | |||
| Error handling error # 1004 Run-time error | Excel Programming | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Error 2029 using Find XL 97 | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Threaded Mode
