I have a spreadsheet with multiple sheets and two of these sheets I need to hide (sheet1 and sheet2). I have a macro that copies data from sheet1 to sheet2. If I hide the sheets, I get a runtime error. How can I simplify my code so I don't have to include in my code commands to unhide and hide my sheets? Thanks


Sub Copy_with_sheets_hidden()
'
' Copy_with_sheets_hidden Macro
' Copies data from Sheet1 into Sheet2
'

'
    Sheets("Sheet1").Select
    Columns("A:C").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Columns("A:C").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
End Sub