I should add that if a cell in your range contains a formula such as

=if(A1="","","")

which would always return a null string then your test would evaluate as
TRUE for this cell despite it containing a formula.

Mike

" wrote:

I have a very strange error in Excel 2003:

All cells in column AZ are empty. When I run this code:

If Range("AZ" & intCounter).Text = "" Then

it says that the cells contain the value TRUE.

How can this be possible?

Very grateful for help!

// S