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. |
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 |