On Error Resume Next

[Jiptastic]

Whenver I have the code

Please Login or Register  to view this content.

the VBA will error if all the data is already showing. I want the code to continue so I'm using

Please Login or Register  to view this content.

. However, I would like to undo this command right after the problem code so that I will be alerted to any other errors. How would I do this?

[Norie]

Try this.

Please Login or Register  to view this content.

[mike7952]

This should do it

Please Login or Register  to view this content.