View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default I can't select a range in VBA

hi
i'm not getting an error on my 2003 with your code.
try this with no select.....
Columns("F:L").EntireColumn.Hidden = False

just to see what happens

regards
FSt1

"bigjim" wrote:

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