VBA - Counting Characters in Cell

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

For example:

Len(Range("A1"))

--

Vasant



"ajocius" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> ajocius
> ------------------------------------------------------------------------
> ajocius's Profile:
> http://www.excelforum.com/member.php...o&userid=17695
> View this thread: http://www.excelforum.com/showthread...hreadid=395220
>

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

Hope this helps
Rowan

"ajocius" wrote:

>
> 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
>
>
> --
> ajocius
> ------------------------------------------------------------------------
> ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
> View this thread: http://www.excelforum.com/showthread...hreadid=395220
>
>

Thanx for the replies, they work perfectly.

Tony