Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Running VBA Macro | Excel Discussion (Misc queries) | |||
Sheets Skip Macro | Excel Discussion (Misc queries) | |||
Macro for moving sheets | Excel Discussion (Misc queries) | |||
running totals in a macro for each month | Excel Worksheet Functions |