I'm new to macro, but most certainly not to excel formulas. I figured due to the logical approach this would be fairly simple with the "record macro" feature, but I'm growing frustrated. Note: this is office 2013.
My goal is this:
Click one of three buttons.
Button 1 must show column F and hide G:I
Button 2 must show column G and hide F, H:I
Button 3 must show columns H:I and hide F:G
Simple enough right?
Everytime I get to the bold step utilizing the "step in" (F8) for visual basic instead of highlighting JUST column F (or any column i try to put in there), it selects C:F instead of just F:
Sub Macro6()
'
' Macro6 Macro
'
'
'
Range("F1").Select
Columns("F").Select
Selection.EntireColumn.Hidden = True
Columns("H:I").Select
Selection.EntireColumn.Hidden = True
Columns("E").Select
Selection.EntireColumn.Hidden = False
End Sub
Note: the above isn't the proper code, i've just been trying to troubleshoot what does what and how. I've narrowed it down to this reality...it keeps selecting C through whatever column. It's driving me mad. I've been working on this spreadsheet for 2 solid work weeks and this is tying me up. Please help
Bookmarks