Hi all .. Love some help on this.
I have a Macro Button in Cell AF2 that opens up the next 6 columns [which are hidden]. Rows 2 & 3 have their panes frozen so it acts as a header for column identifiers.
Each sheet has 100 rows so the officer can be in as low as row 105.
What I want to do is when they click on the UNHIDE button from cell AG92, once the unhide function completes I would like it to go to AH92 which is the next cell along.
I have this so far ..
' reassess_open Macro
' Macro recorded 16/12/2005'
Selection.EntireColumn.Hidden = False
Instead of going to AH5 I want it to go to the AH value of the row they are in.