Edit macro to skip over #ref! cells

[uncleslinky]

Hi there,

I have a worksheet which contains links to a folder where documents will eventually be placed. Currently the links all read "0" however when the relevant workbook in placed into the folder then the values will update. I have a macro (below) which looks up column F o see if the workbook has been placed into that folder. If so then the entire row is to be paste special/value.

As the macro is doing this some cells are turned into "#ref!" errors (as the relevant worksheet is not in the folder to be linked to), this makes my code stop running. Is there a way to skip over these ref cells so that my macro can continue to up column F and paste special where appropreiate.

Please Login or Register  to view this content.

Thanks!
:-D

[uncleslinky]

hi again,

i think ive resolved this by using the "iserror" function in another column

Thanks