Thread: Using Worksheet Function Find in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bcmiller[_2_] bcmiller[_2_] is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote