Selecting ALL names when using Insert/Names/Apply

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there any way to select all names in the name list with out having to
click on each name individually when using Insert/Names/Apply?? I wonder why
the CTRL and SHIFT options are not allowed?

Thanks in advance. Mike
 
Mike

Whay would you want to select all the names?

Perhaps there is something else can be done to achieve your goals.


Gord Dibben Excel MVP
 
I have 17 workbooks with up to 8 sheets each and over 500 names in each
workbook. But I need to replace(using APPLY) all the cell locations in all
the calculations. I just want to highlight each sheet and APPLY all.

Thanks. Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to get range names to Apply across multiple tabs 1
named ranges? 7
Excel Concatenate Form Name to Parse for function 1
naming cells using insert > name> define 2
What are the steps to fix damaged MDF files in SQL Server? 0
Return Names From List 2
Excel Named Ranges and Conditional Format 3

Back
Top