Search results

I am trying to copy some information from one worksheet using the macro below but am getting error messages. Any ideas? Sub Copyscenarios() Sheet1.Activate Range("A2", "AV60000").Select Selection.Copy Application.Workbooks.Open ("C:\Dokumente und Einstellungen\S86QLQM\Desktop\AZAP sales comp...