ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Font size in Excel VBA (https://www.excelbanter.com/excel-programming/296895-change-font-size-excel-vba.html)

george

Change Font size in Excel VBA
 
hi there, I want to change the font size using a macro, if
theres a way pls help me with this.


kkknie[_75_]

Change Font size in Excel VBA
 
Range("C3").Font.Size = 12

You can find out the answers to questions like these by recording
macro while doing it manually and then perusing the code generated.



--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Change Font size in Excel VBA
 
activecell.Font.Size = 14

--
Regards,
Tom Ogilvy

"George" wrote in message
...
hi there, I want to change the font size using a macro, if
theres a way pls help me with this.





All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com