I have a worksheet that every month when running a month roll over VBA code, creates a new month column on the right side Therefore increasing the number of columns. I have frozen the left hand column with the row labels. I am using code in a form to go to the particular worksheet however I would always like to show only the last 12 columns. I have acheived this using commands like "ActiveWindow.SmallScroll ToRight:=-9" to reposition the spreadsheet where I want. THis works fine until the spreadsheet is viewed on another PC with a different screen resolution and the Worksheet positions differently.
Is there a command that will look for the last colums and scroll the worksheet to it showing only the last columns only.
THanks
IC
Is there a command that will look for the last colums and scroll the worksheet to it showing only the last columns only.
THanks
IC