Posted to microsoft.public.excel.programming

bcmiller[_2_] bcmiller[_2_] is offline

external usenet poster

Posts: 1

Using Worksheet Function Find in VBA

I am trying to use the worksheetfunction find to establish whether
text string contains a comma or not (refer below)

testComma = WorksheetFunction.Find(",", ResultsValue, 1)

I have also tried

testComma = iserror(WorksheetFunction.Find(",", ResultsValue, 1))

However, if the string does not contain a comma I get a run-time erro
1004

Unable to get Find propert of WorksheetFunction class.

Any tips would be appreciated

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find text - worksheet function or macro?	sebh007	Excel Discussion (Misc queries)	6	January 8th 07 12:53 AM
Find last non-blank row with a worksheet function	Bruce	Excel Worksheet Functions	2	November 25th 05 05:10 AM
Can the find/replace function be used for worksheet headers/footer	wz7y2k	Excel Worksheet Functions	0	March 21st 05 05:05 AM
Worksheet Function - Find?	DAA	Excel Worksheet Functions	2	February 24th 05 04:15 PM
for stats worksheet in XL how do i find the minitab function	freethrow18	Excel Worksheet Functions	1	February 2nd 05 05:38 AM

All times are GMT +1. The time now is 11:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us