Hi
Use len(cCellValue) to get the characters count.
As for the dates, excel stores internally as the number of days
elapsed since 1-Jan-1900
for eg. 24-Oct-2010 is stored internally as 40475 days, the len value is 5.
Hope this helps
On Wed, Jun 29, 2011 at 1:33 AM, Jon Kanas wrote:
> I hav
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
