Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowAllData shows everything - way to have hidden _not_ show up?
The syntax below is fantastic. It "unfilters" everything. I added part of
the code to 4 printing scripts so that after printing, the records would all be shown. Like I said, it works very well for filtered records. --------------------------------------------------------- Sub ShowAllData() ' ' On Error Resume Next ActiveSheet.ShowAllData If Err.Number < 0 Then MsgBox "All the data is being displayed." On Error GoTo 0 End Sub --------------------------------------------------------- What I just noticed is that as we now have a number of closed records that no longer need tracking, I hid those rows from the ones still in progress. So we no longer need rows that are hidden to be revealed. The code above does not distinguish between hidden or hidden due to filtering. I'm guessing there might not be a way around that but figured I won't know till I ask. Ultimately, we need to unhide rows that have been filtered but not that have actually been hidden. Is there a way to programmatically have Excel distinguish between the two? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.ShowAllData shows everything - way to have hidden _not_show up?
Not that I know.
But maybe you could add a helper column and use that as a flag. Then .showalldata and come back and filter on that flag column to hide the flag. This may be a better way to keep track/count stuff, too. (Especially if someone unhides things by mistake.) StargateFanFromWork wrote: The syntax below is fantastic. It "unfilters" everything. I added part of the code to 4 printing scripts so that after printing, the records would all be shown. Like I said, it works very well for filtered records. --------------------------------------------------------- Sub ShowAllData() ' ' On Error Resume Next ActiveSheet.ShowAllData If Err.Number < 0 Then MsgBox "All the data is being displayed." On Error GoTo 0 End Sub --------------------------------------------------------- What I just noticed is that as we now have a number of closed records that no longer need tracking, I hid those rows from the ones still in progress. So we no longer need rows that are hidden to be revealed. The code above does not distinguish between hidden or hidden due to filtering. I'm guessing there might not be a way around that but figured I won't know till I ask. Ultimately, we need to unhide rows that have been filtered but not that have actually been hidden. Is there a way to programmatically have Excel distinguish between the two? Thank you. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format shows on formula bar, 5 digit numbers show in row | Excel Discussion (Misc queries) | |||
function details show value, but display shows #n/a | Excel Discussion (Misc queries) | |||
ShowAllData | Excel Discussion (Misc queries) | |||
Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions | |||
vba-showalldata | Excel Programming |