| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Find abend on XP/Excel 2003
Below code got subscript out of range abend on XP/Excel 2003, but works find
on excel 2000. Does range.Find function not working on Excel 2003? Any suggestion? oriReportStartRow = oriRowIndex + oriBlankLine + oriHeaderLine + oriTOTALLine oriGPStart = oriReportStartRow objSheet(orisheet).Cells(oriReportStartRow - 1, 1) = "Gross Profit" objSheet(orisheet).Cells(oriReportStartRow - 1, 1).Font.Bold = True oriRowIndex = oriReportStartRow 'test find statement Dim oriSearch As Range Set oriSearch = objSheet(orisheet).Range("A2:IV100").Find("Gross Profit", LookIn:=xlValue) ---- Abend subscript out of range??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find / replace in excel 2003 | New Users to Excel | |||
| I could not find XML in Excel 2003 Data | Excel Discussion (Misc queries) | |||
| Excel 2003 SP3 - can't find the .cub files | Excel Discussion (Misc queries) | |||
| How do i use the find and replace in excel 2003 | New Users to Excel | |||
| how do i find the colors in excel 2003 | Setting up and Configuration of Excel | |||
Threaded Mode
