Printing names

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

Howard Kaikow

There is a View option to see formulae, so I can print the formulas.

What about names?

I can write code to list the names, put I'd rather print with names
displayed.
Is there an option to do this in Excel 97, 2000, 2002, or 2003?
 
Nothing built into excel that I know.

But if you're just looking (not printing), then change the window's zoom to 39%
(or smaller) and you'll see the names of the ranges.

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

(Instead of writing my own.)
 
Insert | Name | Paste | Paste List (button)
Not exactly what you wanted but...
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Howard Kaikow"
wrote in message
There is a View option to see formulae, so I can print the formulas.
What about names?

I can write code to list the names, put I'd rather print with names
displayed.
Is there an option to do this in Excel 97, 2000, 2002, or 2003?
 
Jim Cone said:
Insert | Name | Paste | Paste List (button)
Not exactly what you wanted but...
Click to expand...

I have code that creates a list of names, but Paste List does show the dead
names (names with broken references).
I'll change the macro to list the dead names.
 
Dave Peterson said:
Nothing built into excel that I know.

But if you're just looking (not printing), then change the window's zoom to 39%
(or smaller) and you'll see the names of the ranges.
Click to expand...

You have better eyes than I.
 
Select a multiple cell contiguous range and name it. Then try it. You'll see
it much clearer.

The name for a single cell won't be shown--I can't see it anyway.
 
Hi Howard,

I know you are not using 2007 but an FYI - In 2007 you can filter the "broken" names. Formulas, Name Manager, Filter, Names with Errors. (or Names without Errors). Then you can delete these in one step.

If what you are trying to do is list the dead names as indicated below in <2007, then use the Paste List command and apply an Auto Filter, and go from there.

Cheers,
Shane Devenshire
Microsoft Excel MVP
 
Hi Howard,

I know you are not using 2007 but an FYI - In 2007 you can filter the
"broken" names. Formulas, Name Manager, Filter, Names with Errors. (or
Names without Errors). Then you can delete these in one step.

If what you are trying to do is list the dead names as indicated below in
<2007, then use the Paste List command and apply an Auto Filter, and go from
there.

Thanx.

Actualyl, I was not interested in getting a list of the dead names, but
turns out, that could be useful.

I am programmatically creating a workbook, so there should not be any dead
names, but I can use PasteList to make sure that I did not screw up.
 
Back
Top