Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equivalent VBA for MID/FIND formula
I'm stumped. I have a mid-find formula that I can create on a
worksheet [=MID(B2,FIND("categoryId=",B2)+11,5)] that I can't get to do what I want in VBA. What I need VBA to do is use this formula but use a range variable for a cell I've already DIM'd and SET instead of B2. Or, is there a way to turn the above forumula into a VNA function? MID works the same in VBA and Excel, but I can't find what in VBA works the same as Excel's FIND. VBA's find is like the Ctrl-F find capabilities. TIA, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The equivalent of a Find & Replace option | Charts and Charting in Excel | |||
EQUIVALENT for this FORMULA , please | Excel Worksheet Functions | |||
How do I create an equivalent VLOOKUP function using FIND? | Excel Worksheet Functions | |||
Formula equivalent of CurrentRegion | Excel Worksheet Functions | |||
I need the equivalent formula for this UDF | Excel Programming |