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.HTML Code:
Thanks
Jaz
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.HTML Code:
Thanks
Jaz
Sincerely
Jaz
IDFind.Offset(1).name = "NewRow"
Thanks Scott, it seems it is working. I will check it thoroughly when I am at my desk.
Thanks again
Jaz
Are you talking about putting the name into the Name Manager? If so, then if the insertion is Row 33, in workbook "Sheet1"
![]()
ActiveWorkbook.Names.Add Name:="NewRow", RefersTo:= "=Sheet1!$33:$33" ActiveWorkbook.Names("NewRow").Comment = ""
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks