View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default ITERATING A SINGLE CELL!

Hi
1. VBA:
msgbox len(range("A1").value)

2. Worksheet formula
=LEN(A1)


--
Regards
Frank Kabel
Frankfurt, Germany

jay dean wrote:
What code is used to iterate a single cell? Example: If I wanted to
count the number of characters written in a particular cell.

Any help would be appreciated. Thanks.
Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!