I am needing to move data from document A to document B and change the font in the process. There are many cells to be moved in various combinations. Document A the font is Arial 14 and the destination documents are in Calibri 12 with $ and "," separators.

Can the font and format be changed with one VBA command or does each cell need to be coded after placing it in the destination document?

Although most users rarely make use of the cell styles, this would be the logical way to deal with this.

If your source document cells all have a particular style applied to them (that includes a font of Arial 14) and the destination document has the same style name BUT with different settings (Calibri 12 with $ and "," separators) then you can simply copy and paste normally with no extra formatting steps required.

If you format cells by applying styles rather than adding local formatting then you will find transferring content between workbooks can be greatly streamlined.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia