I have a macro that copies the values from one workbook to another. it copies all the formats and pastes only the values ignoring any formulas. I tried integrating the following code to make the print area of the destination file same as my source woksheet but doesn't work. Could you tell me why? I am new to excel programming and unable to figure out much. I have to d it for one more page. So incase there a simpler way to do it kindly suggest.
Windows(GeneratorFile).Activate (Source)
Sheets("SMOE-FRONT").Range("A1:AX90").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$AX$90"
ActiveSheet.Range("A1:AX90").Copy
DestinationBook.Sheets("SMOE-FRONT").Activate(Destination)
Sheets("SMOE-FRONT").PageSetup.PrintArea = "$A$1:$AX$90"
Bookmarks