Excel-VBA Solutions

Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Check whether font is bold in a cell

When developing VB programs for excel sheets, some times we need to track certain columns, rows or cells.

For an example think you have to do calculation for each and every cell in a excel sheet, only if there column heading is bold.

So below code can be used to check whether cell "A1" is bold or not


   If DR.Range("A1").Font.Bold = True Then
        Do the calculation
   End If

Contact Form

Name

Email *

Message *