Naming range

  • Thread starter Thread starter Kimmie
  • Start date Start date
K

Kimmie

Does anyone know how to name a range, so that I can
export from excel into outlook?
 
Several ways, easiest being to highlight it and put a name in the name box
(to the left of the formula box)
 
try
range(mynamedrange).select

--
Don Guillett
SalesAid Software
(e-mail address removed)
BerHav said:
Don,

I have never used Named Ranges. So, is there a way to get them
Click to expand...
displayed/highlightened in Excel? Or even an overview, etc.
 
Not sure if this is what you want BUT ....
Once you've named all your 'named ranges' and if you then want to view
a list of them go to a 'clean' area on the worksheet (you'll need at
least 2 clear columns), place the cursor in a cell where you want a
list to commence, then Insert/Name/Paste/Paste List.

This will list all the Named ranges within the workbook complete with
their cell references.
 
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

Naming a Data Range 2
How to Convert EML to PST? 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
How can I migrate MBOX to PST? 2
Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
Contacts from Excel to Outlook 1
How to Export Gmail Emails to PST Format? 4
Missing Define option from Insert/Name menu 2

Back
Top