Excel Macro Help

[andy_sea]

Hi,

I am new to Excel Macro programming. I am trying to record a macro that would do subtotals of some data that I have got.

When I click data->subtotals, I receive a Micorosft excel pop showing some message. I always click "OK" on this box and proceed.

But this particular step is not getting recorded. Whenever I play the Macro recorded, it stops here and waits for me to click the "OK" button.

Can anyone please tell me how to work around this problem.

Thanks
Andy

[spyrule]

To get an idea of what is happening, it's best that you post the macro code. It's too hard to troubleshoot otherwise.

Oliver.

[andy_sea]

Please find below the code for subtotals:

Selection.Subtotal GroupBy:=1, Function:=xlCount, TotalList:=Array(1), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
End Sub

But I get the Microsoft message box after this step which is not getting recorded. It is waiting for me to click the "OK" button and then proceeds.

Thanks,
Andy

[Bryan Hessey]

Please find below the code for subtotals:

Selection.Subtotal GroupBy:=1, Function:=xlCount, TotalList:=Array(1), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
End Sub

But I get the Microsoft message box after this step which is not getting recorded. It is waiting for me to click the "OK" button and then proceeds.

Thanks,
Andy

Does the macro you run include the setting of a Range or ActiveCell? - or did you set that before running the macro, and What is the error message?

---