Assign fixed values to array / For...Next loop

Hi All!,

Can you please help me with below situation?

I have written some VBA codes and running them for the same kind of activities on some fixed integer values, for example ---> 45, 90, 91, 92, 93, 94, 95, 95, 96, 100.
I am able to run For...Next loop from 90 to 96, but unable to cover the other numbers like 45 and 100 with it, so I have to write & run the same codes separately for these two. I felt that Array can handle this situation, so tired to google, but not got the success.

Below are the codes in two methods for example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance!

Please Login or Register  to view this content.

Thank You Mr snb!!

Nice to see you again!

Please Login or Register  to view this content.

Just an important question: —»» Do I not need to use below lines? Above is also running without these below lines.
'Dim iArr(45 To 45, 90 To 96, 100 To 100) As Integer
'Erase iArr()

I didn't use an array variable; so there's no need to declare a variable you do not use.

As long as you refrain from 'Option Explicit' the code I posted suffices.

okay.. got it!
» While using 'Option Explicit', Array is fine in the above case. There is no need to define Dim for iArr
» If I don't use 'Option Explicit', then I always should define Dim for the array and later Erase that in the last (e.g. - two lines in green color).

Thank you a ton for explaining it more!!
Merry Christmas in advance!