Insert Name Paste List
 

Hi.

I've just started using office 2007, I can't seem to ask the right question
in Excel help to find out how to produce a list of named ranges in Excel 2007.

Can anyone recomend a good book which helps?

Regards

Phil

Insert Name Paste List
 

Philip J Smith wrote:
Hi.

I've just started using office 2007, I can't seem to ask the right question
in Excel help to find out how to produce a list of named ranges in Excel 2007.

Can anyone recomend a good book which helps?

Regards

Phil

MACRO:-

Range("A1").Listnames

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

Insert Name Paste List
 

Hi Francois.

Thanks for this.

However in Excel 2003 I simply clicked on a few command bars to get this.

Insert, Name, Paste List and I got a list at the cell indicated - I don't
want to start writing macros which duplicate excel functionality.

I really want to know which in which ribbon this functionality has been
hidden.

Regards

Phil

"Francois via OfficeKB.com" wrote:

Philip J Smith wrote:
Hi.

I've just started using office 2007, I can't seem to ask the right question
in Excel help to find out how to produce a list of named ranges in Excel 2007.

Can anyone recomend a good book which helps?

Regards

Phil

MACRO:-

Range("A1").Listnames

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1

Insert Name Paste List
 

Philip

See Ron de Bruin's site for where the commands are located.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

On Thu, 24 Jan 2008 08:17:03 -0800, Philip J Smith
wrote:

Hi Francois.

Thanks for this.

However in Excel 2003 I simply clicked on a few command bars to get this.

Insert, Name, Paste List and I got a list at the cell indicated - I don't
want to start writing macros which duplicate excel functionality.

I really want to know which in which ribbon this functionality has been
hidden.

Regards

Phil

"Francois via OfficeKB.com" wrote:

Philip J Smith wrote:
Hi.

I've just started using office 2007, I can't seem to ask the right question
in Excel help to find out how to produce a list of named ranges in Excel 2007.

Can anyone recomend a good book which helps?

Regards

Phil

MACRO:-

Range("A1").Listnames

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1