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

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