ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   KB 831824 does not completely solve the Subtotals Bug !! (https://www.excelbanter.com/excel-discussion-misc-queries/74184-kb-831824-does-not-completely-solve-subtotals-bug.html)

Jake-M

KB 831824 does not completely solve the Subtotals Bug !!
 
There are too many postings on this to reply to every one.

Implementing the instructions in 831824, there are still occasions where
this bug occurs. I have a simple example I'd be happy to e-mail anyone upon
request to jacob dot moskowitz at db dot com. I'm goiing to try calling
Microsoft again about this, but it looks like I'll have to implement the
whole subtotals function in VBA. In the past, I also had a post-subtotals
VBA kludge to reposition the sub-headings rows, but it was imperfect, then
831824 , and it worked for 2 levels. After I added a third level, it fails
in about 5% of the cases.



All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com