View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Freddie Ang Freddie Ang is offline
external usenet poster
 
Posts: 4
Default Help on macro error when arranging pivot rows

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
--
Freddie