+ Reply to Thread
Results 1 to 4 of 4

Active row and named ranges

  1. 02-01-2022, 08:40 AM #1
    Samet1805 is offline
    Registered User
    Join Date
    06-04-2018
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    54

    Active row and named ranges

    Dear all

    I hade a macro with the code
    Please Login or Register  to view this content.
    I wan't to work with named ranges, so I gave the name "range_1" to column A.

    but now my code isn't working anymore
    Please Login or Register  to view this content.
    Do have to change anything else in the code?
    Reply With QuoteRegister To Reply
  2. 02-01-2022, 09:38 AM #2
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,482

    Re: Active row and named ranges

    Untested, but try: 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-01-2022, 09:42 AM #3
    Samet1805 is offline
    Registered User
    Join Date
    06-04-2018
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Active row and named ranges

    works perfect, thanks!
    Reply With QuoteRegister To Reply
  4. 02-01-2022, 12:11 PM #4
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,482

    Re: Active row and named ranges

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Delete Named Ranges from Active Sheet
    By NonStopLeo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-08-2018, 03:45 AM
  2. [SOLVED] VBA creates named ranges, but named ranges disappear
    By BrotherNeptune in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2015, 03:22 PM
  3. Finding the named ranges that the active cell is a part of
    By HitTheEXCELerator in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2015, 12:35 AM
  4. Define only 2 named ranges from a list of named ranges...
    By abhi900 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2014, 04:20 AM
  5. Looping Mutliple Named Resized Ranges in next empty row below another named range
    By gingumdog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2014, 08:15 PM
  6. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  7. Copying all named ranges from active worksheet
    By lad29 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2011, 04:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1