Need Help on highlighting entire row in VBA

My current Code i am using works good for what I am doing now I would like to highlight the entire row with a Range of (r, 1) to r, 24)

Sub comment_void()
' only additional comment, won't delete the row
Dim r As Long, t As Integer
Dim c As Integer
c = colum(4)
r = ActiveCell.Row
t = ActiveCell.Column
If Cells(r, 2) = "" Then
Exit Sub
End If
Application.ScreenUpdating = False
If c > 0 Then
Cells(r, 21).Value = "Void File: " & Cells(r, c).Value
Else
Cells(r, 21).Value = "Void"
End If
Cells(r, 1).Value = "Noise Test"
Cells(r, 2).Value = "Noise Test"
Cells(r, 9).Value = ""
Cells(r, 11).Value = ""
Cells(r, 12).Value = ""
Cells(r, 13).Value = ""
Cells(r, 14).Value = ""
Cells(r, 15).Value = ""
Cells(r, 19).Value = ""
Cells(r, 20).Value = ""
Cells(r, 1).Font.Bold = True
Cells(r, 2).Font.Bold = True
Cells(r, 21).Font.Bold = True

Cells(r, t).Select
Application.ScreenUpdating = True

End Sub

Not sure if this helps or not:

Please Login or Register  to view this content.

BTW the forum rules require using code tags when posting. See Rule No. 3.

That worked, and thank you i will also look at Rule No. 3. thanks for the heads up

You're welcome. Glad to help out and thanks for the feedback. You may also want to check out Forum Rule No. 9. as well.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.