Hi,
I have created a macro for a table I made. Macro works fine, except when I refresh my dataafter running the macro, my data file changes from:
=OFFSET(DATA!$A$1,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$1:$1)) to:
=OFFSET(DATA!#REF!,0,0,COUNTA(DATA!#REF!),COUNTA(DATA!$1:$1))
I do not know what...