By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,988 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,988 IT Pros & Developers. It's quick & easy.

Paste Special - Keep formatted cells

P: 13
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
Share this Question
Share on Google+
1 Reply


100+
P: 267
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.