Sign up, and you'll be able to customize your font size and more! Sign up
Nov 28, 2014
9:29:17pm
Pardon my ignorance ...
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?
Doozy
Previous username
jlingo
Bio page
Doozy
Joined
Dec 7, 2007
Last login
May 19, 2021
Total posts
4,037 (40 FO)
Messages
Author
Time

Posting on CougarBoard

In order to post, you will need to either sign up or log in.