Printing cell addresses

  • Thread starter Thread starter KSB
  • Start date Start date
K

KSB

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.
 
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

|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.
|
 
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.
 
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
 
Back
Top