+ Reply to Thread
Results 1 to 5 of 5

Naming a new row in VBA

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-08-2005
    Location
    Silicon Valley, CA USA
    MS-Off Ver
    2013 - Using 64 bit system
    Posts
    275

    Naming a new row in VBA

    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.

    HTML Code: 
    Any help will be appreciated.
    Thanks
    Jaz
    Sincerely
    Jaz

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Naming a new row in VBA

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

  3. #3
    Forum Contributor
    Join Date
    12-08-2005
    Location
    Silicon Valley, CA USA
    MS-Off Ver
    2013 - Using 64 bit system
    Posts
    275

    Re: Naming a new row in VBA

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

  4. #4
    Registered User
    Join Date
    12-18-2012
    Location
    Houston TX
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Naming a new row in VBA

    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 = ""

  5. #5
    Forum Contributor
    Join Date
    12-08-2005
    Location
    Silicon Valley, CA USA
    MS-Off Ver
    2013 - Using 64 bit system
    Posts
    275

    Re: Naming a new row in VBA

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1