| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA UDF Userdefined function - search in partially empty fie
Hi,
I wrote a function that tries to find a text in a a range of 5 cells. If they are all poplated it works fine. If one of them is empty the .find command doesn't work anymore. What can I do? The line in my function is: Set Reslt = Sheets("Data").Range("C5:G5").Find(s, LookAt:=xlPart) Thanks, Eckhard P.S. Bob, thanks for your reply to my other post. It works perfectly. Can you help again? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VBA UDF Userdefined function - in which line is the function | Excel Programming | |||
| sumif function with partially matchin sentences | Excel Discussion (Misc queries) | |||
| Userdefined Function and recalculatiing XL 2k3 | Excel Programming | |||
| How to use multiple sheets with range in userdefined function. | Excel Programming | |||
| UserDefined Function that opens another w/book | Excel Programming | |||
Linear Mode
