I am copying a worksheet into different workbooks depending on a certain criterion and then deleting the worksheets in the scrapbook to free up memory. I am able to copy the sheets into the other workbooks fine but the problem is if I try to delete the worksheet in the scrap book I get an error saying a formula is changed and the charts copied into the new workbook don't work any longer.
How do I copy and then just past values into a new workbook. Currently I am copying the sheet in with the code below:
scrapbook.Worksheets(firmname2).Copy after:=reportbook.Sheets(1)
I have also tried to copy all of scrapbook.worksheets(firmname2) and paste special values prior to it being copied into the report book but there are charts within the scrapsheet so they don't get picked up in a range.
Please help.
Thanks.
How do I copy and then just past values into a new workbook. Currently I am copying the sheet in with the code below:
scrapbook.Worksheets(firmname2).Copy after:=reportbook.Sheets(1)
I have also tried to copy all of scrapbook.worksheets(firmname2) and paste special values prior to it being copied into the report book but there are charts within the scrapsheet so they don't get picked up in a range.
Please help.
Thanks.