Naming a new row in VBA

[jazbath]

Hi guys,

I have declared "NewRow" as range.
Through the code I inserted a new row after finding my target.
I want to name this row as NewRow.

Any help will be appreciated.
Thanks
Jaz

[scott.s.fower]

IDFind.Offset(1).name = "NewRow"

[AdamBecker]

Are you talking about putting the name into the Name Manager? If so, then if the insertion is Row 33, in workbook "Sheet1"

Please Login or Register  to view this content.

[jazbath]

Thanks Scott, it seems it is working. I will check it thoroughly when I am at my desk.
Thanks again
Jaz

[jazbath]

Thank you Adam,
I wanted to refer it later in my code to input data in that row. I do not want to name into the name manager.
Thanks anyway.
Jaz