Printing cell addresses

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.

Niek
Sat Nov 10 14:08:49 PST 2007

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KSB" <nospam@optonline.net> wrote in message news:829267DD-B512-455A-8083-51EBF6D841EA@microsoft.com...
|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.
|

KSB
Sun Nov 11 06:47:52 PST 2007

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.


"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:uOfRDZ%23IIHA.484@TK2MSFTNGP06.phx.gbl...
> 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
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "KSB" <nospam@optonline.net> wrote in message
> news:829267DD-B512-455A-8083-51EBF6D841EA@microsoft.com...
> |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.
> |
>
>

Gord
Sun Nov 11 08:16:15 PST 2007

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

On Sun, 11 Nov 2007 09:47:52 -0500, "KSB" <nospam@optonline.net> wrote:

>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.
>
>
>"Niek Otten" <nicolaus@xs4all.nl> wrote in message
>news:uOfRDZ%23IIHA.484@TK2MSFTNGP06.phx.gbl...
>> 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
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>> "KSB" <nospam@optonline.net> wrote in message
>> news:829267DD-B512-455A-8083-51EBF6D841EA@microsoft.com...
>> |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.
>> |
>>
>>