I would like to use the following code but am getting an error when trying to insert a blank line?
Thanks so much in advance!
Sub Spacerz()
Dim Spacer As Range
'Insert New Line Seperator
For Each Spacer In ActiveSheet.Range("AB2:AB200")
If Spacer.Value = "0" Then Spacer.EntireRow.Insert
Next Spacer
End Sub
Bookmarks