Hi
I'd like to hide a couple of columns in a sheet, if the columns are visible, without defining additional variables.
I also don't want to use the Sheet name - I'd prefer to use the Sheet number that appears in the VBA editor.
Let's assume the columns are D and M.
And the Sheet is called "Cool Sheet" but is Sheet 4 in the VBA editor.
Does anyone know how to do this?
Thanks in advance.
I'd like to hide a couple of columns in a sheet, if the columns are visible, without defining additional variables.
I also don't want to use the Sheet name - I'd prefer to use the Sheet number that appears in the VBA editor.
Let's assume the columns are D and M.
And the Sheet is called "Cool Sheet" but is Sheet 4 in the VBA editor.
Does anyone know how to do this?
Thanks in advance.