I have the below macro i recorderd to format sheets in excel, I get an error on the second line of this sheet - 1004 Object defined error. Its no different to any of the other sheets, so i dont understand what the error is.
Sheets("ASSUMPTIONS").Select
Range("A1:H1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$H$78"
Can anyone help?
Sheets("ASSUMPTIONS").Select
Range("A1:H1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$H$78"
Can anyone help?