When I copy one Excel cell to other cell, it copies the format of the cell, as well as the content. When I want to copy the contents, but not the formats, I have to select "Paste special" -> Paste only "values", or only "formulas".
Most of the times I just want to copy the values or the formulas, but not the formats of the cells. Can I change the configuration of the standard "Paste" command, so that it just copy the formulas and not the formats?
Best Regards
I don't think its possible to change it so everytime you copy it only pastes the values....of course there are others with more knowledge than me who may be able to help, but if you look here it will give you an idea where you can have a button on your toolbar that when you click it will paste to your chosen cell, so you could copy in your normal way click the destination cell then click the button and it will paste special values only, you can use the macro recorder to record the paste special action and then paste that code to the button.
Not all forums are the same - seek and you shall find
Good morning jorgefherrero
Add this code to each of the workbooks you want to add this functionality to. In the ThisWorkbook module :
In a normal module :
Please Login or Register to view this content.
This will add a custom toolbar to your workbook on opening with just one button, that will copy formulae only.Please Login or Register to view this content.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
I have included the macro, and works perfectly!!
Thanks a lot to both, Simon Lloyd and dominicb, for your help!!
Best Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks