Combining numbers and strings to generate random output

Question

I have the following code that produces a random number from 1 to 36. I would actually like to produce a random string from the names btn1 to btn36. Is there a way to do this?

Dim Low As Double
Dim High As Double
Low = 1
High = 36
R = Int((High - Low + 1) * Rnd() + Low)
Sheets("ITEMS DATA").Range("K21").Value = R

Paul Sasik · Accepted Answer · 2011-04-13 14:56:32Z

2

Yes. A simple string concatenation will work. Just append your random number to a "btn" string prefix like this:

Sheets("ITEMS DATA").Range("K21").Value = "btn" & R

answered Apr 13, 2011 at 14:56

Paul Sasik

81.9k23 gold badges152 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining numbers and strings to generate random output

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related