This probably has a very simple solution but maybe it's Sunday, not sure.
I have a number of worksheets that have various amounts of data in each worksheet. Throughout the month/year each individual worksheet has been scrolled across to an unspecified location on that worksheet. Each sheet varies.
At a certain time, I run a set of instructions that clears the contents of each worksheet, except for the first 5 columns. There is also a freezepane in use at column E
What I would like to happen is for each sheet to return so that the columns can read as follows
A B C D E (VERTICAL FREEZPANE) F G H I J etc and not look as
A B C D E (VERTICAL FREEZPANE) HI HJ HK HL HM etc
Is this possible and if so could you give me an idea of the coding