So I've recently learnt there's this thing called vba, and I'm trying to automate the update of one of the spreadsheets I use at work.
I've manage to create new tabs, import pivot tables and make all the data generally lovely. The only problem is the summary page. I want to copy last quarters summary, paste it (easy peasy) then replace the title of the worksheet the data needs to be taken from. When I recorded the macro and replaced everything, it worked perfectly, so I assumed the macro would work. When I reversed my operations and ran the macro to do it, not only did it replace what I wanted it to replace, but it also filled every blank cell with the value I put in the replace bar. Is there a variable I need to declare in order to stop it filling blank cells? I've googled it but nothing relevant comes up.
Thanks in advance,
James
Bookmarks