Hey all,
Been using Excel for a long time and never really touched VBA - was always told not to use it as not transparent enough (working in corporate finance)
Anyway... was asked to do something and for the life of me i cant!
I need to find a way to copy across the 'view' from one tab onto an identical tab. Both these tabs already exist so cant make a new tab and populate.
I need to copy across the page freezes and zoom etc, with the idea being when u select a tab and hit the macro, it takes the current setting and applies it to the selected worksheet.
The next step is then to put the cursor into the same cell on the selected sheet/sheets as it was on the active worksheet.
Any help would be much appreciated.
Def trying to build up my VBA knowledge at the moment!!
Been using Excel for a long time and never really touched VBA - was always told not to use it as not transparent enough (working in corporate finance)
Anyway... was asked to do something and for the life of me i cant!
I need to find a way to copy across the 'view' from one tab onto an identical tab. Both these tabs already exist so cant make a new tab and populate.
I need to copy across the page freezes and zoom etc, with the idea being when u select a tab and hit the macro, it takes the current setting and applies it to the selected worksheet.
The next step is then to put the cursor into the same cell on the selected sheet/sheets as it was on the active worksheet.
Any help would be much appreciated.
Def trying to build up my VBA knowledge at the moment!!
