Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting Excel Cells
- Thread starter jonnyk
- Start date
Well if you're using the Range object to populate the cells then do the following:
Dim rngRange as Excel.Range
;-)
Dim rngRange as Excel.Range
Code:
rngRange = oExcel.Range("A1")
rngRange = "TextInTheCell"
Range.Cells.Font.Bold = True (or whatever you're doing to format it.);-)
- Status
Similar threads
- Locked
- Question
