Office 2013
I have 2 sheets in a workbook, our users access Sheet A, and Sheet B is hidden containing source data. The goal is to have users select something in Sheet A, then VBA goes into Sheet B located the item then copy the entire row or column into Sheet A. Works great when both Sheets are visible and using VBA's .find and .activate. But Activate doesn't work when the sheet is hidden, ideally, I don't want to show end users the hidden sheet. How can I accomplish this without unhide and re-hide the sheet. Thanks in advance.