Hello Forum....
I'm a novice troubleshooter when it comes to excel VBA, I'm getting a runtime error '70' permission denied on my code, any suggestions would be appreciated. It's a VBA that takes cell values from worksheet 'CT_Checks' and pastes them in another worksheet named 'History' in a single row. Each cell in 'CT_Checks' points to a specific column in a row of the worksheet 'History'.
Cheers,
Contigo.
Please Login or Register to view this content.
Last edited by Leith Ross; 08-05-2013 at 01:38 AM. Reason: Added Code Tags
where exactly does the error happen?
Josie
if at first you don't succeed try doing it the way your wife told you to
Hello,
I've created a "button" to initiate the save to the correct worksheet....that's where the issue initiates.
Cheers.
I mean which line of the code?
error.JPG
I've attached an image of where the issue initiates in the code.
Cheers.
what is 'Date'? a variable or control? (it's not a good name for either because it's a native VBA function name)
Thanks Joseph, I've since changed the name from Date to something more banal and it has taken care of the issue!
Cheers, thanks for the heads up.
you're welcome :-)
please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks