New to VBA and I am building reports and with to do things with ROW titles.
I can get individual statements to Bold cells to work but would be much better code to do using with Statement.
This works
OutSheet.Cells(OutLineNum, "A").Font.Bold = True
OutSheet.Cells(OutLineNum, "B").Font.Bold = True
OutSheet.Cells(OutLineNum, "C").Font.Bold = True
OutSheet.Cells(OutLineNum, "D").Font.Bold = True
OutSheet.Cells(OutLineNum, "E").Font.Bold = True
OutSheet.Cells(OutLineNum, "F").Font.Bold = True
OutSheet.Cells(OutLineNum, "G").Font.Bold = True
OutSheet.Cells(OutLineNum, "H").Font.Bold = True
OutSheet.Cells(OutLineNum, "I").Font.Bold = True
OutSheet.Cells(OutLineNum, "J").Font.Bold = True
I have tried various ways of putting With Range.. statements but none seem to work.
OutSheet and OutLineNum are declared as Public
Can someone tell me correct way to do a WITH statement for this.
Much appreciated
John
Bookmarks