View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SS[_3_] SS[_3_] is offline
external usenet poster
 
Posts: 14
Default Not Hiding Columns

When my code runs, if columns F - P are not already
hidden, the following code is not hiding them


ActiveSheet.Columns("F:AM").Select
Selection.EntireColumn.Hidden = True

I ultimately want all columns from F to AM to be hidden in
certain circumstances, but if a portion of the columns
have been previously unhidden it will not hide them again.

Thoughts?

Thanks

SS