Results 1 to 4 of 4

Macro to select cell after last row in column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Macro to select cell after last row in column

    Hi,

    Can any tell me the macro code to select the cell after the bottom of a column of data e.g. I have data in A1:A300 and I require the macro to automatically calculate the last row in the range (in this case A300) and then to select A301 (in this case)

    (I know I can record a macro but the number of rows can potentially differ every time I run the macro)

    Many thanks in advance

    Regards Rob

    N.B. Excel version 2003
    Last edited by robertguy; 09-21-2009 at 05:42 AM. Reason: To mark resloved
    Rob

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