<insert<name<paste displays a list of Named Ranges
that you you can pick from to use in a formula. Since I use Named Ranges
quite a bit, I just use the [F3] shortcut, instead.

Example:
If I have A2:A100 named: Sales
I can sum those values by....
Type: =SUM(
Press: [F3]....Select "Sales" from the list
Type: )
Press: [ENTER]

The resulting formula is: =SUM(Sales)

I've never had much use for Label Ranges...
but here's an explanation and example:
http://www.bettersolutions.com/excel...E824631331.htm

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel
"Studebaker" wrote in message
...
I typed in a label in B1 called My Sales. I used InsertNameCreate to
create
a named range for B2 to B10 with the My Sales label I typed as the named
range.

I understand that if I click InsertNameApply it will replace the B2 to
B10
range I have already used in a formula with the name, My Sales. So what
does
InsertNamePaste do?

Also, what does InsertNameLabel do? I thought I created labels just by
typing them into the spreadsheet at the top of the column of data I want
to
label.

Thanks