Macro to skip the error and process to next VBA

[shiva_reshs]

Hello,

My code >

Please Login or Register  to view this content.

When Excel do not find "Invoice Amount, I want excel to go to Last VBA, that is Columns("B:B"). auto fit and do nothing in column B.

Please advice
Regards,

[ragavan.sridar1]

Hi Shiva,

Did you tried the on error goto errorhandler

after endwith give the Errorhandler.

[ragavan.sridar1]

Hi Shiva,

Did you tried the on error goto errorhandler

after endwith give the Errorhandler.

[Norie]

Move the End If down.

Please Login or Register  to view this content.

[shiva_reshs]

Hi,

I am not good with VBA . I just take help of this site on all my coding
Could you please specify , where/How i need to add Error Handler please.

Regards
Shiva

[shiva_reshs]

let me check, Norie. I would reply on my findings. Thanks

[shiva_reshs]

Hi Norie,

It gives me a error

Please Login or Register  to view this content.

Error Message is "Paste Special method of Range class failed"

[Norie]

So if the find works you want to do the copy and paste, but if not move straight onto the autofit?

Please Login or Register  to view this content.

By the way, this code will do the find and replace an every cell in the worksheet.

Please Login or Register  to view this content.

Do you not want to restrict it to a specific range?

[ragavan.sridar1]

Try this way..

Please Login or Register  to view this content.

[shiva_reshs]

I am copying the value from the Pivot table and I am copying multiple tables from there.
Give you and example, Annul turnover Pivot data. But when I run a pivot on different month's, there are cases when there is no invoice amount on a certain month. So when I run Pivot on that month, Invoice data do not show in Pivot table.

The code which I found, gives a message box, that Invoice amount is not found, but it still goes and try to paste it in Summary - qtr sheet, giving a hard error to stop the VBA. Thats why i need something which skips it if it is not found and paste nothing in coloumn B.

I hope that answer your question why I cant restrict to specific range.

Now for your question on

Please Login or Register  to view this content.

Next to Pivot, I added some calculation. Like G7/F7-B7. When there is nothing found in G7/F7-B7 it answer to #DIV/0! and also copy #DIV/0! amount in my summary-qtr sheet. So I needed that code to remove #DIV/0! from the cell. I mistakenly typed only 0 instead of #DIV/0! while pasting the code in my question. Sorry for the confusion.

Thanks

[Norie]

The last code I posted (post #7) will only do the copy and paste if the find is succesful.

If the find isn't succesful then the message box will be shown and the code will move onto the autofit.



Why not change the formula so you don't get any #DIV/0! errors?

Please Login or Register  to view this content.

[shiva_reshs]

Hi Raga,

Your code did not give any error, but it still copies the earlier copied data and paste it into coloumn "B"
I am using a repetitive code to copy the required row again and again. Please see below code.

Please Login or Register  to view this content.

Any workaround on this?

Thanks

[shiva_reshs]

Norie, I am testing your code. Will post update here.!

Thanks

[shiva_reshs]

Hi Norie,

Your code worked. I dont know what I missed earlier when you posted your code on (Post # 8). Thanks for your help!
Can you suggest the coding for to avoid getting #DIV/0 please.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thanks!!!

[shiva_reshs]

Thanks Raga for helping this out!! I will close this thread once I receive reply from Norie.

You guys are the best! Reps added.

Regards
Shiva!

[Norie]

See my earlier post about changing the formula to avoid the #DIV/0! error.

[shiva_reshs]

got it. Thanks