andyb313
08-09-2013, 03:24 AM
Here is my macro:
Sub ProdPaste()
'
' ProdPaste Macro
'
'
Sheets("Paste Here").Select
Range("A2").Select
ActiveSheet.Paste
Sheets("Agency Hours").Select
End Sub
It does not work when the sheet Paste Here is hidden.
I have tried but cannot figure out the code to perform these actions without the .select and selecting the sheet. Can anyone help?
Thanks in Advance
Andy
Sub ProdPaste()
'
' ProdPaste Macro
'
'
Sheets("Paste Here").Select
Range("A2").Select
ActiveSheet.Paste
Sheets("Agency Hours").Select
End Sub
It does not work when the sheet Paste Here is hidden.
I have tried but cannot figure out the code to perform these actions without the .select and selecting the sheet. Can anyone help?
Thanks in Advance
Andy