This works fine...thanks a lot.
"Max" wrote:
Not sure, but you could try something like this in B1:
=IF(COUNTA(B2:B10)0,"hardcoded name","")
If anything is entered in any cell within B2:B10,
B1 will display: hardcoded name
otherwise B1 will remain "blank"
Adapt the range to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mac5" wrote in message
...
What I would like to do is autofil a cell with hardcoded name when a cell
on
the same row is updated. I.E. if data is entered in cell B2,B3,B4 ETC.
then
the 'hardcoded name' will be placed in B1