I have a macro which is supposed to provide a view of my database, however, when I run the macro, it will not work.
What I'm trying to get the macro to do is hide the following columns:
but when I run the macro it hides G through M, and O through Z. I have tried to break the macro down into several smaller macros and "call" them in a master macro for that series of macros, but I continue to get the same results.
Here is the master macro:
Code:
Sub View_Fiscal()
'
' Macro1 Macro
'
Application.ScreenUpdating = False
Call Unhide_Contra_Info
Call VF_1
Call VF_2
Call vf_3
Range("a1").Select
End Sub
Private Sub VF_1()
Columns("G:M").Select
Selection.EntireColumn.Hidden = True
Range("a1").Select
End Sub
Private Sub VF_2()
Columns("P:P").Select
Selection.EntireColumn.Hidden = True
Range("a1").Select
End Sub
Private Sub vf_3()
Columns("T:Z").Select
Selection.EntireColumn.Hidden = True
Range("a1").Select
End Sub