Solved ColumnScroll to reset to Column A

December 1, 2013 at 07:29:03
Specs: Windows 7
Hi Guys,
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


See More: ColumnScroll to reset to Column A

Report •

#1
December 5, 2013 at 14:13:56
✔ Best Answer
Application.Goto Sheets(WorksheetName).Cells(1, colNum + 20), True
Problem solved with this line of code

Report •
Related Solutions


Ask Question