Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine Cells(5,4) IN SPITE of hidden rows/columns
I have a sheet that toggles hidden values of certain rows and columns
to accommodate the views of data for different users. Trouble is, in addition to this, some rows are permanently hidden as once they are too old - but not deleted to keep as reference. In each of the views, position of the freeze panes is different. Always in the same position in the eyes of the user, but a different cell every time an old row becomes hidden. In a nutshell, with a sheet with unknown hidden rows/columns, how could you pinpoint position (5,4) according to what you see, not what is both shown and hidden? thanks in advance and I hope that is clear enough |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Hidden rows/columns expand when referencing cells? | Excel Worksheet Functions | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
determine if there are hidden rows in a column | Excel Programming | |||
hidden rows/columns | Excel Discussion (Misc queries) |