Hello,
I am not familiar at all with VBA, but have learned to record a macro and then edit the contents in VBA. I have a daily report that I make modifications to in order to highlight key cells and such. After I run my macro, I get some header rows that are too high, and would love to reduce the height for these header rows. My header rows contain the text "----------". That being said, I cannot figure out how to write an IF THEN code to make this happen. What I have is below. Please help. Thank you in advance.
Sub row_height()
With Application.ReplaceFormat.Interior
For Each cell In ActiveSheet.UsedRange
If cell.Value = "----------" Then Rows.RowHeight = 20.4
End With
Bookmarks