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 8:28 AM, GoldenLance wrote:
> sCell
sCellValue = ActiveCell.Text
On Jun 29, 1:03 am, Jon Kanas wrote:
> 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 = sCe
