Paste and Compare

[DPWVPA]

I set up a workbook so that I can paste information on two separate worksheets in that same workbook and verify that the two sheets are exactly the same. My problem is that some of the cells show up with the green arrow errors in which I have turned off that function but they still show as being different when the sheets are compared. I figured out that I can use text to columns to fix the issue. I put the text to columns function in the macro to run before it compares the two sheets. Is there a way to skip columns that have no data or is there a better way to do this?

 

[DPWVPA]

I figured out something that works. Since text to columns does what I need to do, I used On Error Resume Next which skips the blank columns. Thanks.