if len(application.trim(c))0
or <1

--
Don Guillett
SalesAid Software

"Axel" wrote in message
...

Just curious
If I have a code that eksample
TextBox1.Text = ""
and
ActiveCell = TexBox1.Text
When I then run a code later to find the empty cells, the cell is not
empty (Looks like it empty).
This code wont find the cell
For Each c In ActiveSheet.Range("something")
If Not IsEmpty(c) Then Something
Next c

I had to write a ClearContens in the code to make above code find the
empty cell
Isn't "" the same as empty?

Thanks

Aksel


*** Sent via Developersdex http://www.developersdex.com ***