Hi,

I'm not sure how you tested and came up with the result you did but

MsgBox Range("AZ" & intcounter).Text

Will return a number if that's what's in the cell

Mike

" wrote:

After some more testing I've found that the problem is that
"Range("AZ" & intCounter).Text" returns nothing if the cell content
only contains numbers. If I change to "Range("AZ" & intCounter).Value"
it returns the content also if the content only is a number. Why
doesn't it return the content with .Text?

// S



On 21 Jan, 10:52, "Nigel" wrote:
You are applying a logical test...... if is = "" ....which will evaluate
TRUE, if the cell is empty, FALSE otherwise.

--

Regards,
Nigel


wrote in message

...



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- Dölj citerad text -

- Visa citerad text -