Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bold Last Row
I am trying a few methods to select the last row in each sheet (using a for
next loop) and bold the entire row, but nothing seems to be working. My code is below: Dim lastrow as Long lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row With Range("A" & lastrow) ..Font.Bold = True End With I tried this too: Rows(X).EntireRow.Font.Bold = True Nothing has worked yet! Please help!! Thanks, Ryan--- -- RyGuy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bold Last Row
Sub BoldLastRow()
Dim wks As Worksheet For Each wks In Worksheets wks.Cells(Rows.Count, "A").End(xlUp).EntireRow.Font.Bold = True Next wks End Sub -- HTH... Jim Thomlinson "ryguy7272" wrote: I am trying a few methods to select the last row in each sheet (using a for next loop) and bold the entire row, but nothing seems to be working. My code is below: Dim lastrow as Long lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row With Range("A" & lastrow) .Font.Bold = True End With I tried this too: Rows(X).EntireRow.Font.Bold = True Nothing has worked yet! Please help!! Thanks, Ryan--- -- RyGuy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bold Last Row
Awesome!!! Thank you so much Jim!!!
-- RyGuy "Jim Thomlinson" wrote: Sub BoldLastRow() Dim wks As Worksheet For Each wks In Worksheets wks.Cells(Rows.Count, "A").End(xlUp).EntireRow.Font.Bold = True Next wks End Sub -- HTH... Jim Thomlinson "ryguy7272" wrote: I am trying a few methods to select the last row in each sheet (using a for next loop) and bold the entire row, but nothing seems to be working. My code is below: Dim lastrow as Long lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row With Range("A" & lastrow) .Font.Bold = True End With I tried this too: Rows(X).EntireRow.Font.Bold = True Nothing has worked yet! Please help!! Thanks, Ryan--- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing in excel always comes out in bold even tho bold not on | Excel Discussion (Misc queries) | |||
Alphabetically list of last names: BOLD, not bold | Excel Discussion (Misc queries) | |||
Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
conditional formating bold is true not bold false how | Excel Programming | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) |