Hi. I have a worksheet where a formula will populate a cell (eg: L4) when another cell (A4) has been updated.
When I press exit/close the spreadsheet, I would like to have VBA that copies cells L4:L27 and
pastes as values prior to closing. Could someone please show me the code to do this. Thank you so much for
the help offered.
Paste them where?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Assuming you were to paste them to M4:M27, the following code would work
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi.
I have added code as shown and I get a 'Run-time error '13':
Type mismatch
Hi, coach.32,
if you want the action to take place once you deactivate the sheet for the action place this code behind the sheet (right-click on worksheet tab, choose View Code, code goes into the code window):
This code will only get fired once you are one the sheet and activate another one in the workbook.Please Login or Register to view this content.
If you want the ation to fire when you exit the workbook the code needs to be placed in ThisWorkbook:
This code will always save the workbook as well which you should take into consideration.Please Login or Register to view this content.You might also take action in the Workbook_BeforeSave-event.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks