Please forgive another newbie question.
I'm trying to insert a specific number of rows based on a dcount return. Based on recording, the code for insertion is
Selection.EntireRow.Insert
Using F2 for insert shows me this:
Insert([shift])
I don't understand what this is telling me. Is there a way to put a variable in to tell the routine how many rows to insert? Such as the range name where the dcount is? I've attempted several things, but think I'm misunderstanding the required syntax.
Thanks for any help.
Lisa
I'm trying to insert a specific number of rows based on a dcount return. Based on recording, the code for insertion is
Selection.EntireRow.Insert
Using F2 for insert shows me this:
Insert([shift])
I don't understand what this is telling me. Is there a way to put a variable in to tell the routine how many rows to insert? Such as the range name where the dcount is? I've attempted several things, but think I'm misunderstanding the required syntax.
Thanks for any help.
Lisa