+ Reply to Thread
Results 1 to 2 of 2

Select last row of a dynamic range

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    37

    Select last row of a dynamic range

    Hi,

    I have a dynamic range that changes fairly frequently. When it changes, it adds a new row at the bottom and resizes itself. I cannot figure out how to select this new row. I need to select it and type in a new person's name into the new cell. Despite several attempts, I cannot figure out how to select the last row. I cannot use the End(xlUp) or End(xlDown) functions because it goes all the way down to the end of the column instead of the few cells that are part of the range. (All of the ranges on my worksheet are adjacent). I know this is pretty simple, yet I cannot figure it out. Here is my code so far. Thanks for your help!

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    06-05-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2016
    Posts
    110

    Re: Select last row of a dynamic range

    Hey Angelfish13,

    To select 1st cell of the last row, you can try the following:

    Please Login or Register  to view this content.
    This should give you a start.

    Regards,
    Vinod Krishna

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Select Dynamic Range
    By Laylow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-05-2011, 02:37 PM
  2. Select dynamic range.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2011, 03:12 AM
  3. Select a dynamic range
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2009, 07:24 PM
  4. How to select a dynamic (?) range?
    By HelenW in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2008, 06:54 AM
  5. [SOLVED] select dynamic range with dynamic start point
    By Juli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2005, 08:05 PM

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