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