+ Reply to Thread
Results 1 to 3 of 3

Need a macro to continue a series..

  1. #1
    Forum Contributor
    Join Date
    07-08-2009
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    183

    Need a macro to continue a series..

    Basically in B3 I have number 1. I want a macro to go to the next empty cell down and continue the series, i.e. 2. Then if it is ran again it will go to the next cell down and put in 3.

    This is what I want it to do only I don't want it to reference ranges. I added the offset line in but still need to know how to autofill to the nex line down..
    Please Login or Register  to view this content.
    Last edited by mrgillus; 08-13-2009 at 12:40 PM. Reason: "end sub in code was in incorrect location

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need a macro to continue a series..

    Hello mrgillus,

    This macro will AutoFill the column as you described. It will AutoFill by 1 starting with the contents of "B3" on the ActiveSheet.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-08-2009
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    183

    Re: Need a macro to continue a series..

    Thanks sir! I will give that a whirl!

+ 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