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
|