reassignning datarange in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wait statement in macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA - retrieve data on last create named range from previous inserted named range 0
Single Filter to change all Pivot Tables in a Workbook 8
VBA Pivot Table help with data fields 3
Getpivotdata with a lookup functions 1
consolidate data in pivot table 1
Pivot Table Update 3

Back
Top