PC Review


Reply
Thread Tools Rate Thread

List deleting or changing

 
 
=?Utf-8?B?QXNpYWdlZWs=?=
Guest
Posts: n/a
 
      3rd Mar 2007
I have a list of data that was given a name to an area of data though I've
added more data (rows) and the list doesn't work with the new data added and
reverts back to the original named list regardless of row additions anywhere.

How do I change the range of data named to cover the extra data/rows added?
i can't seem to find the right information about this.

Thank you.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      3rd Mar 2007
Try Debra's page at:
http://www.contextures.com/xlNames01.html#Dynamic
Create a Dynamic Range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Asiageek" wrote:
> I have a list of data that was given a name to an area of data though I've
> added more data (rows) and the list doesn't work with the new data added and
> reverts back to the original named list regardless of row additions anywhere.
>
> How do I change the range of data named to cover the extra data/rows added?
> i can't seem to find the right information about this.
>
> Thank you.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare List A to List B, Return List B Items Not in List A zwestbrook Microsoft Excel Programming 4 18th Sep 2008 10:32 PM
Automatically Deleting a List from Another (Larger) List ddethomas@gmail.com Microsoft Excel Misc 2 21st Aug 2007 08:31 PM
Automatically Deleting a List from Another List =?Utf-8?B?ZGRldGhvbWFz?= Microsoft Excel Discussion 1 21st Aug 2007 08:16 PM
find names on list 1 in list 2. list 1 4000 names list 2 400 name =?Utf-8?B?RWQ=?= Microsoft Excel Worksheet Functions 1 4th Sep 2005 12:48 AM
Deleting or Manually Deleting Programs from the Add/Uninstall Program list Amy Bejm Windows XP Basics 3 21st Dec 2003 07:34 AM


Features
 

Advertising
 

Newsgroups
 


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