Macro to Delete rows that have #REF! in column B

[meabrams]

I have a macro that copy’s from another sheet and paste “Values Only” into the activeworkbook. I need a macro that will go sheet by sheet and remove any rows that have “#REF!” in Range(B2:B)

Thank you for your help
Bramz

[meabrams]

I figured out a crude way of getting this accomplished. Hope this might help someone else that is having similar Problems...If anyone has a better way to get this something accomplish please feel free to post it. I will set as solved and the end of he night so about 10 hours from now!

Please Login or Register  to view this content.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[YasserKhalil]

Or May be

Please Login or Register  to view this content.

[meabrams]

I am unable to get your macro to remove the rows that have #REF! As the Value. I think that your macro is looking for a formula error instead of looking at the cell value

[YasserKhalil]

You are right as for post #3 but in Post#4 it is dealing with both the formulas and constants .. Try it again