it sounds like one of your named ranges is not available, generally that
error means that Excel cannot find or cannot select the specified range, also
you might want to consider not naming your ranges in your code to the same
exact names you have in your spreadsheet defined names. So make sure to check
that named ranges are not mispelled.

"gig" wrote:

The error message I keep getting is:

Run time error '1004':

Method 'Range' of object'_worksheet' failed


Thanks