I have a workbook with 4 sheets. Sheets 3/4 has formulas. When sheets 1/2 are formatted with data, I run the macro and it will pull the formulas into sheets 1 and 2 at desinated cells. This macro works fine if all 4 sheets/tabs are visible.
However when sheets 3 and 4 are hidden the macro does not work. Macro error message box reads:
"Run-time error '1004': Select method of Worksheet class failed"
The spreadsheet is used by various departments and I really don't want sheets 3 and 4 to be visible. I tried to hide it but the macro won't work. Also I dragged the scroll bars to hide it but it still appears when I click on sheets 1or 2
Is there a way around it?
Thanks.
Novice.
Bookmarks