Selection vs Objects
 

I am trying to unhide all the rows which are currently hidden using a
starting point as anchor to the test range.

Why does the code below not work?


Range(PosStart, PosStart.End(xlDown)).EntireRow.Hidden = False

Range(PosStart, PosStart.End(xlDown)).Select - selects the correct range

Selection.EntireRow.Hidden = False - unhides the required rows

When used together they achieve the desired effect, but why do I have to use
the selection object, why does it not seem to work when using just objects?

PWS

Selection vs Objects
 

Paul,

It works for me: XL XP, Windows XP Pro.

Set PosStart = Range("B2")
Range(PosStart, PosStart.End(xlDown)).EntireRow.Hidden = False

HTH,
Bernie
MS Excel MVP

"Paul Smith" wrote in message
...
I am trying to unhide all the rows which are currently hidden using a
starting point as anchor to the test range.

Why does the code below not work?


Range(PosStart, PosStart.End(xlDown)).EntireRow.Hidden = False

Range(PosStart, PosStart.End(xlDown)).Select - selects the correct range

Selection.EntireRow.Hidden = False - unhides the required rows

When used together they achieve the desired effect, but why do I have to
use
the selection object, why does it not seem to work when using just
objects?

PWS