you can't do it with a function. You will have to have macro code to do it.
We would need more info to give you a suggestion as to the code

"markexcel" wrote:


I want to make a worksheet function that will search for an empty cell
and then stick a character in it.
"IF" only seems to work with a cell's contents, not with the actual
state of the cell itself

All help appreciated

Marko


--
markexcel
------------------------------------------------------------------------
markexcel's Profile: http://www.excelforum.com/member.php...o&userid=27925
View this thread: http://www.excelforum.com/showthread...hreadid=474206