I wrote a macro that copy’s a specific range from a worksheet and pastes it into another worksheet.
The macro works fine when the worksheet I am copying from is visible. However, when I hide this worksheet, I get an error message when running thismacro, (can’t locate the worksheet ).
Is there a way to copy data from a hidden worksheet with out writing more code to unhide, copy this range and then hide this worksheet?
