CODEWITHSUNDEEP
vbaexcelreferencerangecells
developerto_jrm
developerto_jrm

Reputation: 60

Avoid automatic switch from dynamic table refrence to worksheet and range

I am developing an automated Excel template to handle data and create dynamic plots based on the data. So I select my data from a dynamic table, a shown:

First step

Once I have referenced it, then Excel automatically changes my values to a range, selecting the worksheet that has this data, as shown:

Excel's action to avoid

How can I avoid this automatic change that is made by Excel ?

Upvotes: 1

Views: 37

Answers (1)

neuralgroove
neuralgroove

Reputation: 580

It doesn't matter that excel changes the Table reference to a range. When data is added to or taken away from the table, then the range will be updated in the chart.

Upvotes: 1

Related Questions