Watchdawg
09-02-2020, 06:52 AM
Good morning, guru's! OK, I have a workbook that has a list of items in columns B-E (irrelevant to this discussion I believe). Each of those lines is listed with a sequential number in column "A". The list can grow and shrink daily (today might have 124 lines, tomorrow 250 and the next day 45). I need a command button that will pick a random number from all populated cells in column A, then highlight and select that entire row.
Everything I've found so far required me to put in a start/stop value, or was trying to create random numbers to place into a range, that's not exactly what I'm looking for.
Anyone here that can help? I've played with RandBetween with no success
Thanks in advance!
Everything I've found so far required me to put in a start/stop value, or was trying to create random numbers to place into a range, that's not exactly what I'm looking for.
Anyone here that can help? I've played with RandBetween with no success
Thanks in advance!