VBA A1048576 Import Web Query ?

[Pinaceous]

Hi All;

I'm working w/ Excel 2013, where I'm importing two dynamic web queries, each on a separate worksheet, involving two separate macros.

One of the worksheets in importing the web table via macro, I notice its worksheet ranged ridiculously to A048576, thus making my once under 1,000 KB file now a whopping 10,000 KB file.

Now, I tried to reduce the size by deleting that tab and starting off on a fresh with tab and importing the web query, but when I do the macros I always get errors, where there were no previous errors before.

Secondly, I tried to delete a big chunk of the excess rows in the original sheet, but I come up with the same macros errors that were previously not there before I deleted it.

So, should I live with the file this large (?) or is there a "macro-friendly-way" I can reduce my files size w/o interfering with all of the codes there?

Hope you understand.

Thanks in advance.

R/
-Pin