Hi Marko,
You have information in the subject not included in the question.

What does this mean?
"IF" only seems to work with a cell's contents, not with the actual
state of the cell itself

It was already mentioned that you cannot change
another cell with a function, that also includes itself. A function can
only return a value. If the function is trying to test itself for a value
then you have a circular reference and the problems that go with it.

A cell with a function/formula is never empty, it might have an empty string
for a value, but the cell is not empty if it has a formula or a constant..

You would need a macro, and would need to provide some more information.
What is the range of cells that the first empty cell is to be found in.
-- current column (based on active cell) i.e. down from the active cell
-- a rectangular ranger - across row left to right then next row left to right
Would an empty cell down from active cell be the one, if the next cell
down is not empty.
Where
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bj" wrote in message ...
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