Formula Won't Copy Down

[pmd]

Hi,

I am using the following IF statement to guide users to complete columns B, D and E so that column R auto-completes:

=IF(OR($B$8="", $D$8="", $E$8=""), "You must enter a CI Name, Tag Number and Serial Number before completing this field","Hardware")

I have tried copying the formula down and using Paste Special but I still get references to the original rows (i.e. Row 8). I have other formulas in the sheet and have tested them in coloumn R and I am able to get them to correspond to the relevant row (e.g Row 26, 27 etc for: =IF(ISBLANK(U26),"",VLOOKUP(U26,ModelManu,2,0))

Have checked cell validation is off, data type etc but nothing seems amiss. Any ideas if it's formula related but this doesn't seem to be a logical root cause..?

Tnx

[pike]

Hi pmd
use ...
=IF(OR(B8="", D8="", E8=""),

the $ keeps the valves the same when you drag down

search "relative" in the help file

[pmd]

Perfect - thanks!

[pike]

no problem ..the Excel and VBA help files are your best friend
they have worked examples