hi all, how to make the first row as bold in an excel file....
Printable View
hi all, how to make the first row as bold in an excel file....
how do you assign values to the excel file...
just i will be assigning values to the first row with for loop. i will be numbering from 1 to 30. now i want that first row to be in bold
Do you know what the range of the first line is?
i don no.... just i want to bold that first row only...
But, where is the first row?
Is it in A:? B:? C:?
Excel deals with ranges. You can do anything (pretty much) that you want to a specified range, but you are least need to know where the range starts.
Example: Here is something I pulled out of one of my programs.shWorkSheet is declared As Worksheet.Code:shWorkSheet.Range("A1:Q5").Font.Bold = True
I'm telling it to start at A1 and go down to Q1, then over to Q5 and bold everything in between.