LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Names and changing cell ranges

Hi,

I am building mulitple Charts which over time need to be quickly updated
when the input cell ranges change. I am using Names for the ranges. I am
looking for a quick way to redefine the cell range which each Name refers to.
I know I can do this in the "Refers To" box, but is there a way to pass along
the max and min cell range? I have a lot of Named ranges and it would be
great if they could just grab the needed values from a couple of rows.
 
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
Changing cell addresses to recently added names in existing formul Colts41 Excel Worksheet Functions 3 September 10th 08 07:31 AM
Names of workbook cell ranges not accepted with some signs zzxxcc Excel Worksheet Functions 1 August 20th 07 02:02 PM
IF functions and Names Ranges JaB Excel Discussion (Misc queries) 1 January 18th 07 12:30 PM
Changing cell references in formulas to names and back again. Aaron Excel Discussion (Misc queries) 4 April 25th 06 11:12 PM
formula with changing cell ranges Grant Excel Worksheet Functions 1 August 23rd 05 06:29 PM


All times are GMT +1. The time now is 10:44 PM.

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

About Us

"It's about Microsoft Excel"