Hi there,
I know how to do this using copy, paste special, values only... but I would like to automate it if possible as it is going to come up a lot.
Any help much appreciated.
Regards
Chris
Hi there,
I know how to do this using copy, paste special, values only... but I would like to automate it if possible as it is going to come up a lot.
Any help much appreciated.
Regards
Chris
Date is the VBA equivalent of = TODAY()
Format is similar to =TEXT(...)
Above result in:![]()
Please Login or Register to view this content.
24/03/2017 (default for dates in my Excel setup)
24 03 2017
Fri Mar 2017
Friday March 2017
places B2 value in required format in C2![]()
Please Login or Register to view this content.
Last edited by kev_; 03-24-2017 at 03:21 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
or if you want the equivalent of copy and paste values with the format maintained:
which copies from the active cell and pastes into the cell in the next column![]()
Please Login or Register to view this content.
as does this:
![]()
Please Login or Register to view this content.
Last edited by kev_; 03-24-2017 at 03:33 AM.
Thank you Kev.
I'm not sure how to implement those two pieces of code. I know where to find the script editor but I think there must be some brackets or other characters missing. I guess you probably expect I would know how to do that but i am not that familiar with coding. I tried placing it in various ways but it didn't work. What am I missing?
Regards
Hi Chris
File containing the macros is attached to get you started
Select cell B3 and then {CTRL} t to copy B3 and paste values and format to C3
To get to the VBA area: {ALT} {F11}
Do you have the Developer Tab activated?
If not see here
Last edited by kev_; 03-24-2017 at 10:59 AM.
Thank you Kev, I'll have a look at this tonight.
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks