Help on macro error when arranging pivot rows

  • Thread starter Thread starter Freddie Ang
  • Start date Start date
F

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
 
Hi Steve,

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

Thank you.
 
Back
Top