Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Charting dynamic range
0 views
Skip to first unread message
Jennifer
Sep 25, 2008, 1:02:00 AM9/25/08
to
Ok let me say i fully understand how to name a range and in the source data
use the formula =sheetname!rangename
use the formula =sheetname!rangename
Problem arrises when my macro that runs an advanced filter with the source
data and add data to the bottom of the range the chart reverts back to it's
initial data source =sheet1!$a$4:$b$15
so even though it accept the named range intitailly once the advanced filter
runs it almost ommits the named range. I am using 2007 and i never had this
problem in 2003.
What suggestions do you have for me?
Thank you!!!!!
--
Thank you,
Jennifer
0 new messages