

Formatting
Text and Numbers Using a Macro in Excel


Excel
2007 
Excel
2003 
Home 
Macros
Excel 2003 
Excel
2010 
About
Us 
Free
Ebook 
Offline
Training 
Blog 
Interactive Training 

The complete process is implemented as follows:
Sub calculate() Range("A3:D3").Font.Bold = True Range("A4") = "Tom" Range("B4") = 5000 Range("C4") = Range("B4") * 0.5 Range("D4") = Range("C4") + Range("B4") Range("D4").Font.Bold = True Range("D4").NumberFormat = "$#,##0.00" Range("D4").Font.ColorIndex = 5 End Sub Watch the video below for dtails. 



Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
About Us  Free Ebook  Offline Training  Blog  Interactive Training 