jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
In the immediate window when I do a:
? activesheet.autofilter.range.address
I get:
$A$3:$F$27
In my spreadsheet my row headers 4-24 are BLUE, but my row header in row 27
is the normal black color, indicating it (row 27) is not filtered...
How can I correct?
Excel 2007
? activesheet.autofilter.range.address
I get:
$A$3:$F$27
In my spreadsheet my row headers 4-24 are BLUE, but my row header in row 27
is the normal black color, indicating it (row 27) is not filtered...
How can I correct?
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 3 | Seq | Fruits | Day1 | Day2 | Day3 | Day4 | ||
| 4 | 1 | Apple | 4 | 1 | 1 | 1 | ||
| 7 | 2 | Apple | 2 | 4 | 1 | 1 | ||
| 10 | 3 | Apple | 7 | 2 | 1 | 1 | ||
| 13 | 4 | Apple | 2 | 5 | 1 | 1 | ||
| 16 | 5 | Apple | 5 | 3 | 1 | 1 | ||
| 19 | 6 | Apple | 8 | 1 | 1 | 1 | ||
| 24 | 7 | Apple | 9 | 1 | 3 | 1 | ||
| 27 | 8 | Apple | 5 | 4 | 3 | 1 | ||
| 28 | ||||||||
Sheet1 | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A4 | =SUBTOTAL(3,$B$4:B4) | |
| A7 | =SUBTOTAL(3,$B$4:B7) | |
| A10 | =SUBTOTAL(3,$B$4:B10) | |
| A13 | =SUBTOTAL(3,$B$4:B13) | |
| A16 | =SUBTOTAL(3,$B$4:B16) | |
| A19 | =SUBTOTAL(3,$B$4:B19) | |
| A24 | =SUBTOTAL(3,$B$4:B24) | |
| A27 | =SUBTOTAL(3,$B$4:B27) | |
