errors with Worksheets object

have a line of code that sets the reference for a range:

Please Login or Register  to view this content.

This works without error. However I would like to set this reference for a range on a specific sheet, Sheet2, or "Sales". When I add the worksheets object I get errors, shown below.

Please Login or Register  to view this content.

Run-time error '1004': Application-defined or object-defined error

Please Login or Register  to view this content.

Run-time error '13': Type mismatch

Hi bsapaka,

I am new to VBA and this forum. Not sure if my comments below help but you could have a try :

For Run-time error '1004': Application-defined or object-defined error, I believe there will be a crash to your range "salesHeader" if you run the code to your worksheet "Sales". Instead, probably you may replace as below :

Please Login or Register  to view this content.

For Run-time error '13': Type mismatch , I guess you could just simply add the " " to your sheet name as below :

Please Login or Register  to view this content.

Hope these are able to help.

Cheers,
Leong