VBA - Counting Characters in Cell

[ajocius]

Group,
How can I count the number of characters that appear in a cell?
The characters are in text. The only characters appearing are 0-9, A,
B, C, D, E, F and $. I need to know how many characters appear in a
cell give a Row, Column. Actually it doesn't matter what characters
reside in the cell, the number of characters is the important thing I'm
looking for.

Tony

 

[Vasant Nanavati]

For example:

Len(Range("A1"))

 

[Guest]

len(cells(1,1).text)
or len(cells(1,1).value)

Hope this helps
Rowan

 

[ajocius]

Thanx for the replies, they work perfectly.

Ton