I can't select a range in VBA
I am trying to unhide some columns. I keep getting a "Select method of range
class failed" error. With "Columns("F:L").Select highlighted.
I am using Excel 2003.
I can record the action in a macro and it works, but then copying from the
macro to the button it doesn't work.
I would truly appreciate any help anyone can give me.
Private Sub CommandButton3_Click()
Sheets("Complete Frac Price Book").Visible = True
Sheets("Complete Frac Price Book").Select
Columns("F:L").Select
Selection.EntireColumn.Hidden = False
|