The above macro works perfectly, but when pasting into column I, it loses the formatting. Is it possible to make a change where it doesn't post the formual, only the value (as its currently doing), but keeps the Accounting format with the $ in the appropriate spot. Basically it changes the formatting to currency ($101,000) rather than accounting ($ 101,000).
Please Login or Register to view this content.
Last edited by jharvey87; 03-23-2017 at 01:48 PM.
Try adding "$" & before .Cells(I, "L").Value like so..
Please Login or Register to view this content.
Last edited by gmr4evr1; 03-22-2017 at 04:48 PM. Reason: Added & " " to code
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Maybe:
Please Login or Register to view this content.
Last edited by TMS; 03-22-2017 at 04:47 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, 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
This worked partially. Basically it moved the money, but then the row borders disappeared for some reason. Basically just became white background. Is it possible to have it paste just values in accounting format? Nothing else?
Never mind, i was able to remove the color references and it worked perfectly.
Thank you!
You're welcome.
I understood that you wanted to retain the formatting. I don't recall the original words but I assumed you wanted all the formatting. And I don't remember you stating that it was Accounting format that was the issue though judging by gmr4eve1’s reply, that might have been there.
Please don't change/edit the original post. It can, and does, change the context of any responses and can be very confusing.
I did not edit anything in the original post beyond putting [code] around the code as you instructed in your response. That was the only change.
Either way, thanks for your help!
Ah, fair enough. My apologies, my mistake.
Glad that you were able to adapt the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks