#1   Report Post  
gennario
 
Posts: n/a
Default Remove an array

I have a spreadsheet with 7 different arrays. I only need 1 - how do I remove
the others?
  #2   Report Post  
Otto Moehrbach
 
Posts: n/a
Default

What do mean by "7 different arrays"? Post back and provide more detail
about what you have and what you want to have. HTH Otto
"gennario" wrote in message
...
I have a spreadsheet with 7 different arrays. I only need 1 - how do I
remove
the others?



  #3   Report Post  
gennario
 
Posts: n/a
Default

When setting up arrays for vlook up I created more names in the name box than
I needed. I clicked on a name and tried to delete but it doesn't delete. Was
hoping to clean up the name box to just the one I needed.

Hope this makes sense.

"Otto Moehrbach" wrote:

What do mean by "7 different arrays"? Post back and provide more detail
about what you have and what you want to have. HTH Otto
"gennario" wrote in message
...
I have a spreadsheet with 7 different arrays. I only need 1 - how do I
remove
the others?




  #4   Report Post  
RagDyer
 
Posts: n/a
Default

To remove (delete) names,

<Insert <Name <Define,

Select the name and click on "Delete", then <OK.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"gennario" wrote in message
...
When setting up arrays for vlook up I created more names in the name box
than
I needed. I clicked on a name and tried to delete but it doesn't delete. Was
hoping to clean up the name box to just the one I needed.

Hope this makes sense.

"Otto Moehrbach" wrote:

What do mean by "7 different arrays"? Post back and provide more detail
about what you have and what you want to have. HTH Otto
"gennario" wrote in message
...
I have a spreadsheet with 7 different arrays. I only need 1 - how do I
remove
the others?





  #5   Report Post  
gennario
 
Posts: n/a
Default

AWESOME!!! Worked perfect!! Never would have figured that one out
myself....really appreciate the help!!!!!!

"RagDyer" wrote:

To remove (delete) names,

<Insert <Name <Define,

Select the name and click on "Delete", then <OK.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"gennario" wrote in message
...
When setting up arrays for vlook up I created more names in the name box
than
I needed. I clicked on a name and tried to delete but it doesn't delete. Was
hoping to clean up the name box to just the one I needed.

Hope this makes sense.

"Otto Moehrbach" wrote:

What do mean by "7 different arrays"? Post back and provide more detail
about what you have and what you want to have. HTH Otto
"gennario" wrote in message
...
I have a spreadsheet with 7 different arrays. I only need 1 - how do I
remove
the others?








  #6   Report Post  
RagDyeR
 
Posts: n/a
Default

Appreciate the feed-back.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"gennario" wrote in message
...
AWESOME!!! Worked perfect!! Never would have figured that one out
myself....really appreciate the help!!!!!!

"RagDyer" wrote:

To remove (delete) names,

<Insert <Name <Define,

Select the name and click on "Delete", then <OK.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"gennario" wrote in message
...
When setting up arrays for vlook up I created more names in the name box
than
I needed. I clicked on a name and tried to delete but it doesn't delete.

Was
hoping to clean up the name box to just the one I needed.

Hope this makes sense.

"Otto Moehrbach" wrote:

What do mean by "7 different arrays"? Post back and provide more detail
about what you have and what you want to have. HTH Otto
"gennario" wrote in message
...
I have a spreadsheet with 7 different arrays. I only need 1 - how do I
remove
the others?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the bug in my array? Gail Gurman Excel Discussion (Misc queries) 1 January 25th 05 12:36 AM
Working with array equations OkieViking Excel Discussion (Misc queries) 2 January 23rd 05 07:43 AM
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 17th 04 06:44 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data Dennis Excel Discussion (Misc queries) 4 November 28th 04 10:20 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"