| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
instr problem with formula
I am trying to use the following
If InStr(1, "C:\", Range(strC & r).Formula) 0 Then Print #1, r & strC & " " & " " & Range(strC & r).Formula End If strC = D r = 21 Range(strC & r).Formula = "=(ISERROR(GET PIVOTDATA("EQPSERIAL",'C:\Reports..........." The print statement never happens. Can anyone tell me what is wrong? Thanks -- Shell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use InStr function in formula? | Excel Worksheet Functions | |||
| Len and InStr problem manipulating strings | Excel Programming | |||
| Problem using the INSTR function in VBA | Excel Programming | |||
| InStr | Excel Programming | |||
| Instr function problem | Excel Programming | |||
Threaded Mode
