I add debug statement into my code like countchar = Range("A5").count. Then
add countchar into the watch window.

" wrote:

Hi guys

does anyone know how to get a count of the number of characters in a
cell from the VBA watch window, what do i type?

Im sure this is is such as easy question but Ive exhausted every
possibility of "count, character, excel, VBA" etc in google and I cant
seem to find it!

Many thanks
Oz