Right now I have an input box asking the user to specify a row. Then I want the code to select the row that the user entered in and fill the row with a color. The code I have right now looks like this
Dim divider As String
'declares divider as string, will use to draw yellow dividing line
divider = InputBox("Last Row Minus 2")
Rows("divider:divider").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
It has a problem with the line Rows("divider:divider").Select.
I probably just don't know the correct way to write this line, can anyone lend a hand?