Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
shibao
 
Posts: n/a
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
Running VBA Macro Jeff Excel Discussion (Misc queries) 1 February 15th 05 01:12 PM
Sheets Skip Macro NICK Excel Discussion (Misc queries) 2 February 11th 05 07:16 AM
Macro for moving sheets minhao Excel Discussion (Misc queries) 3 December 10th 04 08:09 AM
running totals in a macro for each month idunnobutheregoes Excel Worksheet Functions 1 November 8th 04 10:35 PM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"