I have several sheets that I need to hide columns in, but the number of columns differs on each sheet.
I can identify the the left most column with Hide1 and the right most column as Hide2. Hide1/Hide2 would always be in row 7 but could be any cell from F7 to M7.
On selection of a cell F10, I would use Private Sub Worksheet_SelectionChange(ByVal Target As Range) to hide the columns from Hide1 to Hide2.
On selection of cell F11, I would unhide the columns from Hide1 to Hide2.
Anyone have any find a word code to set the hide / unhide range...
I can identify the the left most column with Hide1 and the right most column as Hide2. Hide1/Hide2 would always be in row 7 but could be any cell from F7 to M7.
On selection of a cell F10, I would use Private Sub Worksheet_SelectionChange(ByVal Target As Range) to hide the columns from Hide1 to Hide2.
On selection of cell F11, I would unhide the columns from Hide1 to Hide2.
Anyone have any find a word code to set the hide / unhide range...