Help on macro error when arranging pivot rows

[Freddie Ang]

Hi guys,

I got a macro to run a pivot table & rearrange the data rows in a particular
order.
Problem is when a particular data row is not present in my data range, the
macro stops and a macro error pops up for debugging. I then manually shift it
to the next step & run the macro again from there.

How do I overcome this macro error so that I do not have to do it manually.

Many Thanks

 

[Nigel]

Post the code might help.

 

[AltaEgo]

Try Inserting the following line beneath your dim statements

On Error Resume Next


For more information:

http://www.cpearson.com/excel/ErrorHandling.htm

 

[Freddie Ang]

Hi Steve,

I have inserted the text string before the step and it works.

Thank you.

 

[AltaEgo]

Happy to help. Thank you for the feedback.