Thread: [Solved] Excel VBA changing font from source document to destination document
View Single Post
 
Old 07-08-2023, 11:50 AM
BYahr BYahr is offline Windows 11 Office 2021
Novice
  
Join Date: Mar 2023
Posts: 16
BYahr is on a distinguished road
Default 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?
Reply With Quote