VBA Code to Generate Random Numbers in Excel

This code generates random numbers within a specified range and places them in the selected range.

VBA Code:

Sub GenerateRandomNumbers()
    Dim cell As Range
    
    For Each cell In Selection
        cell.Value = Int((100 - 1 + 1) * Rnd + 1)
    Next cell
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment