Loop through random numbers in Excel VBA

Question

I am trying to apply 'For loop' in excel VBA and I have to go to cell numbers 2, 8, 15, 21, 28, 35, 49, 56, 63, 70, 76; as there is no fixed pattern/sequence,I am not able to use Step command, how should I go about it?

Welcome to Stackoverflow! Can you please elaborate your question having your effort like code or something so that people could get your problem early and help you? Thanks! — Enamul Hassan
– Enamul Hassan, Commented Apr 8, 2016 at 3:20

user4039065 · Accepted Answer · 2016-03-17 06:39:30Z

3

Use an array and loop through it.

dim vars as variant, v as long
vars = array(2, 8, 15, 21, 28, 35, 49, 56, 63, 70, 76)
for v = lbound(vars) to ubound(vars)
    'do something with cells(vars(v), <some column>) or cells(<some row>, vars(v))
next v

answered Mar 17, 2016 at 6:39

user4039065

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

Collectives™ on Stack Overflow

Loop through random numbers in Excel VBA

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