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

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

Try Inserting the following line beneath your dim statements

On Error Resume Next


For more information:

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

--
Steve

"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

Hi Steve,

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

Thank you.

--
Freddie


"AltaEgo" wrote:

Try Inserting the following line beneath your dim statements

On Error Resume Next


For more information:

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

--
Steve

"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

Happy to help. Thank you for the feedback.

--
Steve

"Freddie Ang" wrote in message
...
Hi Steve,

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

Thank you.

--
Freddie


"AltaEgo" wrote:

Try Inserting the following line beneath your dim statements

On Error Resume Next


For more information:

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

--
Steve

"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