Sorry again! I copied that out of my spreadsheet and of course I was
not using the same cell references.
=IF(ISBLANK(A2),"",$H$2)
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=486297