LinkBack URL
About LinkBacks
Hmmm, its still taking a long time to run, do you have any other ideas? the problem seems to be that Im copying anf pasting some really long formulas. Evenwhen I try to do a manual copy and paste, the sheet does not update.
Hmmm, its still taking a long time to run, do you have any other ideas? the problem seems to be that Im copying anf pasting some really long formulas. Evenwhen I try to do a manual copy and paste, the sheet does not update.
Hi,
Maybe it's time to upload the workbook (cut down as much as necessary in order to upload) so that we can see the request in context.
One technique I often use to identify the problem area is to step through the macro with the F8 key and see how long the cursor takes to become live and postion itself on the next code line. Usually of course it's instantaneous so doing this you should find which is the line that is taking the time.
You can effectively 'deactivate' any procedure by using a variable and testing the variable as the first line of the procedure. So assuming you want to control the procedure from say the A1 value in Sheet1 then put say the word 'Stop' in A1 and in the procedure
If Sheet1.Range("A1") = "Stop" Then End 'or Exit Sub
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
The code always fails when it gets to the line "ActiveSheet.paste". I think that the reason is because there is just too much data for excel to deal with. the file is about 8 MBs and has several tabs, all of which depend on the tab I'm working on. infact, even when I try to do manually what the code does automatically, excel still runs into trouble when it tries to paste the information.
I'll try to trim down the work file, but its a bit difficult to get it down to 1MB. I'll try to post the file in two pieces with the relevant information.
thanks for the help.
Showing the code would certainly help I am sure.
Show where the code is, Regular Module, Sheet Module or This Workbook Module.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks