View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hamad.fatima@gmail.com is offline
external usenet poster
 
Posts: 2
Default Hide the current month columns

I am creating a monthly forecast sheet. There are columns P to Z listed
as forecast columns with the MOnths ( Jan to Dec).
Cell A1 in the sheet is the currrent month cell which changes every
month.

I want the sheet ot hide the current month column. Suppose if A1= Jan,
then column "P( Jan ) " should hide itself. Similarly if the current
month A1= June then the columns "P to U" should hide.

I would greatly appreciate if someone cold help me with this problem.

Thanks