Hi
How's this
rylo![]()
Sub aaa() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row If InStr(1, Cells(i, 2), "#Break") > 0 Then Cells(i, 1).EntireRow.RowHeight = 9.75 End If Next i End Sub
Hi
How's this
rylo![]()
Sub aaa() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row If InStr(1, Cells(i, 2), "#Break") > 0 Then Cells(i, 1).EntireRow.RowHeight = 9.75 End If Next i End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks