Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This simple macro hides certain columns, then it's supposed to select
cell B3, but it tells me the select methods failed. Sub HideColTop2AC() Dim rTopCell As Range Dim lColTop As Long Dim WkSht As Worksheet For Each WkSht In ActiveWorkbook.Worksheets If Not Right(WkSht.Name, 7) = "Records" Then Set rTopCell = WkSht.Range("3:3").find("top", LookIn:=xlValues, LookAt:=xlPart) If Not rTopCell Is Nothing Then lColTop = rTopCell.Column WkSht.Range(WkSht.Columns(lColTop), WkSht.Columns("AC")).Hidden = True WkSht.Range("B3").Select<---ERROR End If End If Next End Sub Why is the select failing? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
What did I do? (Select Method of Range Class Failed ) | Excel Programming | |||
Select method of Range class failed - but why??? | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming |