whats wrong with this?
What does "doesnt it work" mean to you?
If
(a) there's a workbook-level named range "onepa_ilo_fhc", or if the
named range is a worksheet-level named range and that worksheet is
active, and
(b) the variable basedooranswer = "FLUSH HOLLOW CORE"
then after the code is run, the sheet containing the referenced range
"onepa_ilo_fhc" should be active and the row(s) referenced by
"onepa_ilo_fhc" should be visible.
Works on a test workbook for me.
However, there are any number of other things that could "not work",
depending on the "other code" and a host of other factors...
In article <6d8e377ecec49@uwe, "brownti via OfficeKB.com" <u31540@uwe
wrote:
this is my code inside of some other code.
If basedooranswer = "FLUSH HOLLOW CORE" Then
Application.Goto reference:="onepa_ilo_fhc"
Selection.EntireRow.Hidden = False
End If
why doesnt it work?
thanks
|