Thread
:
Help with this macro
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Help with this macro
Might have been grants vs Grants. Sheet not necessary if on that sheet, etc.
Private Sub Worksheet_Activate()
Rows.Hidden = False
Set rng = Range("a9:a100")
r1 = rng.Find(".").Row
r2 = rng.Find(UCase("FUNDING COUNCIL GRANTS")).Row - 3
Rows(r1 & ":" & r2).Hidden = True
Cells(1, 1).Select
End Sub
--
Don Guillett
SalesAid Software
"nc" wrote in message
...
Please help with the following macro, sometimes it works but when it
doesn't
I get the following error message "Runtime error '91 object variable or
With
block variable not set". It stops on this row, rw1 = rng.Find(".", , ,
xlWhole).Row
Private Sub Worksheet_Activate()
Dim cell As Range
Application.ScreenUpdating = False
Cells.EntireRow.Hidden = False
Set rng = Sheets("income").Range("A9:A100")
rw1 = rng.Find(".", , , xlWhole).Row
rw2 = rng.Find("Funding Council grants", , , xlWhole).Row
Range(Cells(rw1, "A"), Cells(rw2 - 3, "A")).EntireRow.Hidden = True
Cells(1, "A").Select
Application.ScreenUpdating = True
End Sub
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett