Posted to microsoft.public.excel.misc
|
|
reassignning datarange in a macro
Ron,
Thanks for info. works like a charm.....
Regards,
Wilkesy
"Ron Coderre" wrote:
Try basing the Pivot Tables on a Dynamic Range Name, which automatically
expands and contracts with the data. See Debra Dalgleish's website for
instructions.
http://www.contextures.com/xlNames01.html#Dynamic
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Wilkesy" wrote:
i'm using a marco in worksheet A that contains the table data to update
multiple pivot tables / charts in workshhet B. i'm using the name function
to define the rows & columns (called it data) which contains the entire data
range of worksheet A. after i add additional rows of data in worksheet A, i
want to use the macro to 'redifine' the new data range & use that to update
worksheet B. while recording the macro, i started in cell A3 (the header row
where my data starts) & hit the Ctrl+shift+end keys to highlight the data. i
then deleted the name Data & re-added it, thinking this would update the name
data for the Pivot tables / charts. but it doesn't. is there a way or code
that can be used to redefine the name so my tables willget update with the
most recent data?
|