Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Selecting multiple objects by drawing a selection box | Excel Discussion (Misc queries) | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |