Recognising '0.00'

S

Stuart

The following does not appear to recognise a cell
containing the value: 0.00

If Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Value _
= "0.00" Then

How best to amend this, please?

Regards.
 
T

Tom Ogilvy

If Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Value _
= 0 Then

If Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Text _
= "0.00" Then

If Format(Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Value, _
"0.00") = "0.00" Then


The value stored in such a cell would be zero. It is formatted to display
as 0.00 perhaps, but the value stored is zero. .Text will give you what is
displayed, .value will give you what is stored.
 
S

Stuart

Understood. Many thanks.

Regards.

Tom Ogilvy said:
If Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Value _
= 0 Then

If Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Text _
= "0.00" Then

If Format(Pagevarr(j + 1).Offset(-1, ColsToPrint - 1).Value, _
"0.00") = "0.00" Then


The value stored in such a cell would be zero. It is formatted to display
as 0.00 perhaps, but the value stored is zero. .Text will give you what is
displayed, .value will give you what is stored.
Click to expand...
 
Top