| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with this error
Hi i use this:
side =Mid(folder, (InStrRev(folder, "_") + 1)) But not all folder has a underscore I only want to see the folder whit underscore I understand i shall use a If but how??? Regards alvin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help with this error
Hi Alvin,
on error resume next side =Mid(folder, (InStrRev(folder, "_") + 1)) if err< then err = 0 ' underscore not found else 'underscore found end if on error goto 0 Regards, Ivan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help with this error
Hi Alvin,
Try: If InStr(folder, "_") Then side = Mid(folder, (InStrRev(folder, "_") + 1)) End If --- Regards, Norman "alvin Kuiper" wrote in message ... Hi i use this: side =Mid(folder, (InStrRev(folder, "_") + 1)) But not all folder has a underscore I only want to see the folder whit underscore I understand i shall use a If but how??? Regards alvin |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please help with this error
Thanks
its working Alvin "Norman Jones" wrote: Hi Alvin, Try: If InStr(folder, "_") Then side = Mid(folder, (InStrRev(folder, "_") + 1)) End If --- Regards, Norman "alvin Kuiper" wrote in message ... Hi i use this: side =Mid(folder, (InStrRev(folder, "_") + 1)) But not all folder has a underscore I only want to see the folder whit underscore I understand i shall use a If but how??? Regards alvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Hybrid Mode
