But how do I do that? (I did spend the last 20 minutes trying to google this; I'm trying!)
Here's a basic add new row command:
Sub Add_Line_1()
'
' Add_Line_1 Macro
'
Rows("12:12").Select
Selection.Copy
Selection.Insert Shift:=xlDown
Range("C11:G11").Select
Application.CutCopyMode = False
Selection.ClearContents
End Sub
Say I inserted white text (invisible) into A12 the read "NamedCell1". How would I get the macro to find NamedCell1 then select that whole row?