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
View.jpg![]()
Please Login or Register to view this content.
Bookmarks