The following code keeps flaging ActiveSheet.Paste error. Help......
Please Login or Register to view this content.
The following code keeps flaging ActiveSheet.Paste error. Help......
Please Login or Register to view this content.
When you step over the code in which line exactly the code flags an error?
Please Login or Register to view this content.
Don't use ActiveSheet.Paste, you know the destination range you want to paste to so use that.
What exactly are you copying and pasting anyway?Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi,
You don't say which instance of ActiveSheet.Paste (there are several) gives you the error.
However since the procedure is not very efficiently written, upload an example workbook and describe in a note what you are trying to achieve and no doubt someone will provide a more efficient solution.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I was able to make it work, but may still have issues. I cant seem to attach / upload the file. I placed a link to google drive for refernece. Im trying to pull data from 4 worksheets (named) on to 1, creating a masterlist (TSR_Dump). Is it possible to have the marco button on worksheet TSR_Report?
https://docs.google.com/file/d/0B8fU...1MTVR3c0U/edit
Hi,
The FAQ explains how to attach a file. Upload it to this forum.
Then, as I said, forget the current macro - it's not efficient, and explain what you want to achieve and what event you would want to use to kick off any macro. e.g. a simple button, every time you activate a specific sheet, every time you change a cell...whatever.
I have came up with this code, but I am unable to test it as the worksheet is protected.
Please Login or Register to view this content.
My goal is to pull data from the named worksheets, ie... Steve_Zbell, Steve_Randall and create a data "dump" under TSR_DUMP. Then... this info is pulled to the TSR_Report via indirects. with my current crap code, i cant not run the marco "update" button from the TSR_Reports worksheet with out deleteing everything. let me know what you guys think. thanks
My code consolidate the 4 sheet names in to TSR. You can either test it yourself, or unprotect the cells as they are protected.
Estimating_Projects_Tracking_Log_v4_2012_HELP.zip
is this sheet protected?
I have downloaded both of your sheets and both are protected. What I mean is: The cells are protected. When I step over the code to test it, it stops at the begining, giving warning the cells are protected. Go to review and remove the password
Estimating_Projects_Tracking_Log_v4_2012_HELP2.zip
OK now i understand,please try this
The attached is even worse:"Project is unviewable". I can not even view the project as you now have protected the Project enviorment as well.
Have you tested it yourself? I have tried to get around by copying every sheet in to different book, but still not luck. I am still being asked for a pass. I really do not know how to get around this problem. I suggest you test the code and see what it says. We may be able to work with out seeing the sheets.
Where can i turn off this protection? Maybe becuase its coming off a network drive? or is it a stupid exel option. I sent the last file to someone else in my office and they were able to view and edit the code. Try password 123.
Can be your settings maybe:?
http://office.microsoft.com/en-us/ex...55931.aspx#BM3
i appericate your help thus far....
Okay,
It is realy weird file. I am unable to attach it, but here is the code-Tested
What the code does: Copy all rows, except headers, from each 4 names and paste them as values only to dump.
Please Login or Register to view this content.
Nice, it works. Still dont understand the protection issue thou. While i have your attention can you please take a look at this filtering marco i cant seem to figure out. I have attached a example.
Book1_HELP.xlsm
SZBell,
I was partly to blame for the protection issue. The sheet was protected, despite there was no password, I had to go to the dump tab review to unprotect it , so as for the code to work.
Sorry for giving you a hard time, but the bottom line is that you now have a working code.
I think your second request is a different thread. As per forum's rule, could you please post it as a new thread?
I am quite happy to answer any questions you may have regarding the first thread, but I do not want break forum's rule with the second request.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks