About Us

Don Guillett

widen the column?

--
Don Guillett
SalesAid Software

"Barb Reinhardt" wrote in message
...
Anything after the ! in column 2 is not being displayed. What needs to
be
changed?

Thanks

"Don Guillett" wrote:

Sub listnames()
Application.Calculation = xlManual
For Each n In ThisWorkbook.Names
lr = Cells(Rows.Count, "a").End(xlUp).Row + 1
Cells(lr, 1) = n.Name
Cells(lr, 2) = n
Next
Application.Calculation = xlAutomatic
End Sub

--
Don Guillett
SalesAid Software

"Barb Reinhardt" wrote in
message
...
Programmatically, how do I get all of the named ranges in the workbook
to
be
displayed on my Sheet1. I have named ranges that are workbook
specific
and
worksheet specific. I'd like to know the sheet that they are specific
to
if
they are present.

Thanks,

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Transfering 100 named ranges to an another workbook	Oldjay	Excel Discussion (Misc queries)	2	August 8th 07 07:40 PM
Phantom named ranges in a workbook?	Dave O	Excel Discussion (Misc queries)	3	September 26th 06 05:26 PM
Linking to named ranges in another workbook	KG	Excel Discussion (Misc queries)	4	March 30th 06 03:07 AM
Checking for named ranges in a workbook	loopoo[_17_]	Excel Programming	2	November 22nd 05 05:10 PM
SQL query a workbook - too many named ranges?	Dave[_55_]	Excel Programming	0	September 19th 05 06:26 PM