|
#1
|
|||
|
|||
Excel VBA changing font from source document to destination document
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? |
#2
|
||||
|
||||
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 |
Tags |
changing font/format, excel vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Feeding a Word Document from Excel Source (not a mail merge) | Jen75 | Word VBA | 6 | 10-02-2022 11:57 AM |
Changing a selected font from the document | iffee82 | Word | 4 | 04-16-2018 07:07 AM |
Creating Standard Word document using excel source(s) | MagicMan | Word VBA | 1 | 12-01-2017 05:06 PM |
Single step Word Styles from Source Document through entire Destination document? | xbliss | Word | 6 | 08-27-2016 09:36 PM |
Update source for multiple links to excel document | JDHeisenberg | Word VBA | 1 | 08-19-2016 04:23 PM |