Because the OP wants to copy a value from a range, not the entire sheet.

Regards,
GS

" wrote:

Why don't you just use the Sheet copy menus? Click on the TAB you
want copied. Put in the target Workbook, decide where you want it
put, and be sure to check the box to COPY file, click OK.