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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003

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.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003

Understood. Many thanks.

Regards.

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
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.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003