Hi,
I have been using below macro which works fine to export my current workbook to Desktop. However, cells C4:C19, F16:F19 and I16:I19 needs to be copied and saved as values in the file stored on Desktop.
Does anyone know how to add this to below code or perhaps can share a new code?
Kind regards
Please Login or Register to view this content.
Ulrik
Last edited by AliGW; 11-24-2020 at 04:17 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. As you are new, I did it for you today.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear AliGW,
Thank you for your help, I will read the information in your link and I will add the tags going forward.
/Ulrik
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Dear sintek,
Thank you for your feedback.
I have tested with your code and unfortunately the sheet I have open containing formulas is being overwritten to values and the file that the VBA code is saving on the Desktop is still containing formulas. It should be the other way around.
How can I make the VBA code do the opposite? So that the file i have open/active keeps its formulas and the file on the desktop is being saved as values for cells C4:C19,F16:F19,I16:I19
And drumroll...Your sample file is where?
I am a new user, I can't see were on this page I am able to upload a sample file.
Hi ulrik
See Top Yellow Banner
Including Sample.
So what is the issue...Code works...
File saved to desktop contains values...Open file with macro remains as is...
I can only say that it does not work on my computer. Are you perhaps able to send the entire code you are using? In order to make it work.
It is all your code from post 1...just added the red snippet in post 4
Alternative to your code...
Please Login or Register to view this content.
Last edited by sintek; 11-26-2020 at 11:10 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks