I tried recording a macro [twice] but selecting the 'option' in A1 (drop down: All, Pricing, Review) doesn't seem to get me anything.... ![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am trying to dynamically hide/show columns based upon the selection is A1. Something like:
IF A1 = "All" then show all columns
OR IF A1 = "Pricing" show cols A:B, F:J, AND HIDE cols N:P, AF:AN
OR IF A1 = "Review" show cols A,C, F:J, AND HIDE cols B, N,P etc.....
VBA Code:
Sub Macro1()
'
' Macro2 Macro
'
'
Columns("A:AN").Select
Selection.EntireColumn.Hidden = False
Range("C:D,Q:AC").Select
Range("Q1").Activate
Selection.EntireColumn.Hidden = True
End Sub
I am trying to dynamically hide/show columns based upon the selection is A1. Something like:
IF A1 = "All" then show all columns
OR IF A1 = "Pricing" show cols A:B, F:J, AND HIDE cols N:P, AF:AN
OR IF A1 = "Review" show cols A,C, F:J, AND HIDE cols B, N,P etc.....