Recognising '0.00'

  • Thread starter Thread starter Stuart
  • Start date Start date
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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check cells in a column 2
If Select is the solution - how to avoid Select 3
If....Or Logic question 4
.find does not find if .NumberFormat = "#,##0.00" 2
Creating a formula in VBA with quoted strings 1
I am trying to use the IF and SUMIF function on Excel 8
Fill both cells if one cell has a negative amount 2
Fill color if amount is negative 1

Back
Top