Method 'Range' of Object'_Global' Failed Error

First thought is that you spelled something wrong and that either the sheet Problem3 does not exist or the named range PaymentAmount does not exist on the sheet Problem3. Double check for leading and trailing spaces as they matter.

Edit:
Here, run this code as a separate subroutine. It should tell you if what I think is correct.

Please Login or Register  to view this content.