I am trying to make a macro that can create an exact spreadsheet in terms of format as one that I downloaded from online. I set the code to the same size of arial 11 in VBA as below but when I ran the macro the sizes and looks are completely different from each other. View number 1 is the macro with huge text and sized cells, view number 2 is the downloaded spreadsheet. Both of them have the same font as shown. Please assist. Thanks
Range("A3:W121").Select
With Selection.Font
.Name = "Arial"
.Size = 11
End With
View.jpg
Bookmarks