467,161 Members | 850 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Paste Special - Keep formatted cells

I have created a VB code to export data from one worksheet to another, with rows deleted depending upon the value of a cell. My problem is that when this is copied and pasted to the new worksheet, the formatting (particularly the varying currencies) revert to either plain numbers of GBP.

Does anyone know of the correct code to force VB to keep the format of the cells, be it USD, JPY etc?

Help is much appreciated
Nov 21 '06 #1
  • viewed: 1936
Share:
1 Reply
100+
I have created a VB code to export data from one worksheet to another, with rows deleted depending upon the value of a cell. My problem is that when this is copied and pasted to the new worksheet, the formatting (particularly the varying currencies) revert to either plain numbers of GBP.

Does anyone know of the correct code to force VB to keep the format of the cells, be it USD, JPY etc?

Help is much appreciated
hi

easiest way to find out:
go to menu -- extra | macro | record a new macro
then perform the exact operation how you want it done.
close the recording.
look back (Alt+F11) in the module how this macro was recorded
alter anything you want diffently and use this macro anywhere else.
Nov 21 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Faith | last post: by
1 post views Thread by PaulMac | last post: by
3 posts views Thread by Craig Petrie | last post: by
17 posts views Thread by Steve | last post: by
1 post views Thread by dom_perron@hotmail.com | last post: by
1 post views Thread by The Tarm | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.