+ Reply to Thread
Results 1 to 5 of 5

Need a button to post a range of random numbers to the next empty row

  1. #1
    Registered User
    Join Date
    03-07-2020
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    3

    Need a button to post a range of random numbers to the next empty row

    Hey there Community,
    I am working on a small, super simple project and I need a button to paste a range of random numbers into a certain row then in the next empty row of the same range of columns on the next press and so on. I have been using excel for a very long time, but I have done almost no dabbling in VBA coding. I managed to get my Button that generates the random numbers created and I get it to print the numbers where i want them, but I can't figure out how to get them into the next row it currently just replaces the numbers each time i press it.

    Please Login or Register  to view this content.
    This is the code I made for my button and it works great in the initial row. I have looked all over trying to figure out how to get it to post in the next row. Some other threads have covered this problem, but their coding is so complex that I can't even begin to decyfer how to make it work in my simple project. This is a learning project for me, so any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Aeon_Phoenix; 03-07-2020 at 07:36 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Need a button to post a range of random numbers to the next empty row

    you need to find the next available row.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-07-2020
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Need a button to post a range of random numbers to the next empty row

    This works Fantastically, Thank you very much!

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Need a button to post a range of random numbers to the next empty row

    Small change to code, self explanatory.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-07-2020
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Need a button to post a range of random numbers to the next empty row

    Quote Originally Posted by torachan View Post
    Small change to code, self explanatory.
    This one works Very well also. Thank you.

+ 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. Random Numbers (predefined range)
    By ragnadok in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2020, 11:21 AM
  2. [SOLVED] generate random numbers in random range vba
    By hsnfifo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2020, 12:59 PM
  3. [SOLVED] Command Button to Choose Random Number from LIST NOT RANGE
    By Ghostrider55 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2019, 07:21 PM
  4. [SOLVED] Macro to get random cell in a range (Ignoring empty cells)
    By ghoneim in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-24-2017, 11:10 AM
  5. [SOLVED] Pick Random Value from a Range (not including empty Cells)
    By ghoneim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2013, 04:46 AM
  6. Random numbers in range
    By hockey123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2010, 11:22 PM
  7. Button to Generate Random String of Numbers
    By dlenoxx in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-26-2009, 06:37 PM

Tags for this Thread

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