Hi,

Can anyone help me?! In an earlier post I found a solution how to write a
VBA to automatically refresh a pivottable. However I have a small problem
re3garding the 'define name' because my source data is situated somewhere
from A8 to K...(x). How should rewrite the formula in order to make my VBA
work agian?

='2. Template nummerlijst'!$A$8:(INDEX('2. Template
nummerlijst'!$8:$65536;COUNTA('2. Template nummerlijst'!$A:$A);COUNTA('2.
Template nummerlijst'!$8:$8))

Btw; It's not US/English i.e. the ';' where normallly 'a' , would be

Already many thanks

Basta