Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by CarolynKo
-
Find Exact Value in Formula
I'm still playing around with this. Wanted to thank everyone for taking the time to respond. Learned some too about different options/features for use now and/or in the future.- CarolynKo
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find Exact Value in Formula
Fred, thanks for the suggestion. Unfortunately it also finds 1,000,000 and makes it 10,000,000. In essence I need something that works like: find formula where equals (or contains) 100,000 AND not equal to (or does not contain) 1,000,000 Example of formula: =(C11/(sheetoffset(-1...- CarolynKo
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find Exact Value in Formula
PH: Using xlWhole produces the same result. I'll restate the situation for anyone else who might have a solution: In my formulas, I want to Find (and possibly Replace) 100000 (5 0s) with 1000000 (6 0s). When I invoke Find I do not want to be taken to 1000000 (6 0s).- CarolynKo
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find Exact Value in Formula
I need to search my Excel formulas to find 100000 (5 0s) but do not want to find 1000000 (6 0s). Using VBA or built-in Excel Find function takes me to every occurrence of 1000000 (6 0s). Entering 100000 (5 0s) - it's treated as if there is a wildcard, which normally works well, but not in this...- CarolynKo
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
