View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Smith[_3_] Paul Smith[_3_] is offline
external usenet poster
 
Posts: 26
Default 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