I am running the following code to copy and paste from a hidden sheet. I used macro recorder.
Sub test12()'
' test12 Macro
'
'
Application.ScreenUpdating = False
Sheets("Make Ready Board (2)").Visible = True
Sheets("Make Ready Board (2)").Select
Range("A2:R2").Select...