I have a macro which works down through all the cells in a column,
parsing the contents of the cell for a particular text string. Here's
the general outline:
sCellValue = ActiveCell.Value
CharCount = sCellValue.Characters.Count
Found = 0
For i = 1 To CharCount
If the cell contains a date, I get an error on the Characters.Count
although the variabls sCellValue is correct.
My guess was that the cell with the date wasn't text, so
Characters.Count won't work. I tried using the istext function, but
cannot figure out the syntax to test it for true or false. I guess I
haven't ever used any of the boolean functions in VBA.
Any / all suggestions appreciated.
Regards, Jon
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
