Changing cell references from relative to absolute should not give you the
#VALUE error.


Gord

On Mon, 12 Jun 2006 14:14:59 -0500, lostinformulas
<lostinformulas.29azv0_1150139704.9181@excelforu m-nospam.com wrote:


I was able to run the Macro it work in some of the cells however others
received and error message of #VALUE.

The difference between the formulas that work and the one that didn't

The code worked in the cells that had the following formula:

=IF(AND('1'!$AP64="yes",'1'!$A64="yes"),1,"")

The cells that didn't work had the following formula:

=IF(AND('1'!$B64="yes",'1'!$AO64="yes",'1'!$AQ64= "HB",'1'!$D64="yes"),0.5,IF(AND('1'!$B64="yes",'1' !$AO64="yes",'1'!$AQ64="HB"),1,""))

Could it have something to do with the second If statement in the
formula????