| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determing first row in VBA when subtotaling
I keep getting a pop-up when I run my macro stating that excel can not
determine the row I want to use to subtotal from. Is there a way around this? -- Regards, Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determing first row in VBA when subtotaling
Two solutions.
1. Excel makes best guesses based on the layout of your data. There is something in your layout that makes Excel think that you do not have good dtata to subtotal. Fix that and then... no more message. 2. While I have not tried it for thsi applications I think this will work. Just befor doing the subtotal add application.displayalerts = false and after the subtotal rest alerts application.displayalerts = true HTH "Michael from Austin" wrote: I keep getting a pop-up when I run my macro stating that excel can not determine the row I want to use to subtotal from. Is there a way around this? -- Regards, Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determing n=? using COUNT | Excel Discussion (Misc queries) | |||
| Determing Range Criteria | Excel Worksheet Functions | |||
| Determing the SQL Datasource After the Fact | Excel Discussion (Misc queries) | |||
| Determing Value From Date | Excel Discussion (Misc queries) | |||
| Formula for determing average based on weighting | Excel Worksheet Functions | |||
Hybrid Mode
