Hi,
I am having trouble creating this macro:
I am trying to create a macro that can hide particular columns in all sheets in the work book based on the contents of two different cells in the column. For example, if the macro should be able to hide all columns in the workbook where cells A5:Z5 say "DEC" and cell A6:Z6 says "PY". The macro should loop through all sheets and check for the values of those cells. Can anyone assist me with this?
Thanks
Bookmarks