S
shibao
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?
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?