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.
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.
Bookmarks