Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Getting a 1004 error - select method of range class failed - with the
following code: Sub unhide() Dim sh As Object For Each sh In ActiveWorkbook.Worksheets sh.Visible = True sh.Columns.Select Selection.EntireColumn.Hidden = False Next sh End Sub the code is in a module. The macro works for the first sheet of the three-sheet workbook then bombs on the second sheet Thanks in advance PB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel VBA error - Select method of Range class failed | Excel Programming | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
RT Error 1004, Select method of worksheet class failed | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |