ExcelBanter - Find all non-blank cells

That helps - thanks - and sorry for the double post!

"Ron de Bruin" wrote:

You can try specialcells

Record a macro when you do this

Select the range
F5
Special
Constants
OK

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"chaves" wrote in message ...
I have the following code to cycle through a worksheet and find all non-blank
cells

For Each c In ActiveSheet.UsedRange
If c.Value < "" Then
CheckValue
End If
Next

This works, but takes a few minutes - even though there are only roughly 200
non-blank cells.

Any suggestions on how to speed this up? (I also tried "for each c in cells")

Thanks!

Andrew