If the range name is truly dynamic, you don't need VBA. Make sure
calculation is set to automatic.

What version of Excel are you using? I have heard that sometimes 2007 does
not update as expected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Themd" wrote in message
...
Dear all,

I have a data tape with is filtered based on a criteria and is copied to
another separate sheet. On this staging sheet I use offset and counta
functions to dynamically set a range which I use for a chart. Every time
the
data changes the range changes as I want.

On the chart file I insert the name of the range to the data source field
ie. Sheet1!Rangename then it displays the data correctly. however if the
range expands to 5 rows from the initial 4 it still displays the initial
4.
I once read that you needed to create a vba code to make sure that ever
time
it is run it resets the named range. Can you help?