![]() |
calc locks up after running a macro that moves sheets to a new fil
My spreadsheet has a macro that creates a few worksheets of hard coded data,
then moves these sheets into a new file. After I run this macro, however, my original workbook locks up (it will not recalculate, even if changes are made to the inputs). I know that it is the moving of the sheets that is somehow causing this to happen because I have tested the entire macro line by line and it is only after the code to move the sheets is run that this problem arises. This is the line of code I am referring to: Sheets(Array("Summary", "Details", "Entitlement", "Land&Prod", "Signature", _ "Due Diligence", "Special District Fin")).Move I tried to just copy these sheets over to a new file instead, and that seemed to solve the problem, but for other reasons (namely cells with more than 256 characters not completely copying over) I prefer to use the move function. Is this code somehow disabling the spreadheet's ability to calculate, and if so how do I reenable it? Or is it something else entirely? |
All times are GMT +1. The time now is 08:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com