Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
record of records count for display...
For my FILTERED records, I have this code that works.
Set rng = ActiveSheet.AutoFilter.Range Set rng = rng.Offset(1, 0).Resize(rng.Rows.Count - 1, 1) On Error Resume Next Set rng1 = rng.SpecialCells(xlVisible) On Error GoTo 0 If rng1 Is Nothing Then ' MsgBox "0 of " & rng.Count & " rows visible -" Else ' MsgBox rng1.Count & " of " & rng.Count & " rows visible" If Not Intersect(ActiveCell.EntireRow, rng1) Is Nothing Then Set rng2 = Intersect(ActiveCell.EntireRow, rng1) recno = Application.Subtotal(3, Range(rng1(1), rng2)) 'commewnted out 11/10/2003 'recno = ScrollBar1.Value 'added 11/10/2003 ' MsgBox "rec selected is " & recno & " of " & rng1.Count & " visible" Else 'recno = ScrollBar1.Value ' MsgBox "rec selected is " & recno & " of " & rng1.Count & " visible" 'recno = ScrollBar1.Value - Ofs '- (ScrollBar1.Min - 1) ' Recno = ScrollBar1.Value End If End If Label41.Caption = recno & " of " & rng1.Count How can I do the same for when I have the filter flag set to disabled? The sheet may still be filtered, but the HIDDEN are now available. Is there a way to incorperate this with a scroll bar with out MASSIVE rewritting? (this is being called now by my click_up() and click_dn() functions Thanks Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return only 1 record w/ multiple records? | Excel Discussion (Misc queries) | |||
Need to color 1 record of each set of Duplicate Records | Excel Worksheet Functions | |||
How can the count of filtered records always display? | Excel Worksheet Functions | |||
How to merge records into one record by customer's name? | New Users to Excel | |||
Count Records & Display MsgBox | Excel Programming |