Hi

I hope someone out there can help me with the following problem.

I have a formula in G9 which I want use to return the cell address of A9,
and if I copy the formula down to G10 I want to return the cell address of
G10 and so on and so on. The formula works fine, see below;
=ADDRESS(ROW(),1)

I then have another formula which I want to combine with the previous
formula which will tell me if the cell is blank or not. This formula works
fine, see below;
=CELL("type",A9)

I want to able to combine the functionality of these two formulas but do not
seem to able to make any headway. My logic was as follows;
=CELL("type",ADDRESS(ROW(),1))

Perhaps there is a better way to accomplish this? Any help would be much
appreciated.

Kind Regards - Grant