Thread: Help on macro error when arranging pivot rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default Help on macro error when arranging pivot rows
Post the code might help.

--

Regards,
Nigel




"Freddie Ang" wrote in message
...
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

Reply With QuoteReply With Quote