Printing cell addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KSB - 10 Nov 2007 19:52 GMT

I have a large worksheet which acts as a source for several other
worksheets.

Is there any way to print out the column and row headings AS ENTERED and the
cell locations (w112) , not the cell contents or formula. This is only for
set up reasons. I still want the actual value to go onto the slave
worksheets.

Reply to this Message

Niek Otten - 10 Nov 2007 22:08 GMT

Can you give an example of what you'd like to be printed or what you mean by "AS ENTERED"?
I don't have any idea from what you posted

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a large worksheet which acts as a source for several other
| worksheets.
[quoted text clipped - 3 lines]
| set up reasons. I still want the actual value to go onto the slave
| worksheets.

Reply to this Message

KSB - 11 Nov 2007 14:47 GMT

I am referring to the cell address or location, i.e. Column C, Row 27, as
opposed to the cell contents, whether it me a number, formulae, etc.

> Can you give an example of what you'd like to be printed or what you mean
> by "AS ENTERED"?
[quoted text clipped - 9 lines]
> | set up reasons. I still want the actual value to go onto the slave
> | worksheets.

Reply to this Message

Gord Dibben - 11 Nov 2007 16:16 GMT

What types of criteria would determine which addresses to return and display for
printing?

As Niek asked...........what does "as entered" mean in regard to row and column
headings?

You have not provided enough information to hazard a guess at your needs.

Gord Dibben MS Excel MVP

>I am referring to the cell address or location, i.e. Column C, Row 27, as
>opposed to the cell contents, whether it me a number, formulae, etc.
[quoted text clipped - 12 lines]
>> | set up reasons. I still want the actual value to go onto the slave
>> | worksheets.

Reply to this Message

Rate this thread: