This question already has an answer here:
I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in
B2. Basically, I'm looking to use the
INDIRECT() function in VBA. Is there a way to do this?