Trying to use Cell description instead in cell address

[bdouglas1011]

I have a worksheet that looks for empty cells when they try to run a macro. If a cell is empty it returns a message that it need to filled in before you can proceed. How can I get each Cell address to return what the cell represents in message.

Message now" Cell $j$11 must be filled in before sending...

Looking for: PRJ to Bit must be filled in before sending...

Cell j11 = PRJ to Bit (once filled in)

Can you assign each cell to a Description and have that returned instead of the cell address

How can I get this to happen

Please Login or Register  to view this content.

[fredlo2010]

What do you mean by cell description ? How do you add it to the cell?

[bdouglas1011]

The message says as of now " Cell $j$11 must be filled in before sending..."

I would like to to read : "PRJ to Bit must be filled in before sending...

Instead of using "Cell " & cell.Address & " must be filled...

Can I have it return Text (Description) for what information that cell contains.

That way they know what cell to fill in.

It sounds trivial but I have the headers not displayed and guys that are not to savvy with computers don't know where cell $J$11 or how to easy it is to turn back on headers ....so it would be easier to describe the cell that needs to be entered before you can continue


for Example in cell $J$11 the information being entered stands for "PRJ to BIT"

[fredlo2010]

Try this; if the headers are in row 1

Please Login or Register  to view this content.

Thanks