1. The screen shot is unreadable. Use the [#] icon to add code tags and paste the macro between them

2. Best is to add a simple workbook with the macro(s) that show the problem since what causes an error for you might not cause an error for me if I have to re-create a workbook just to test

3. What is a error 438? There are lots of different Excel Error codes, so people might not want to look it up

4. Mark the line that is causing an error.