Quick Array help

[IanWells]

If i was creating an array with sequential numbers from 100 going up to 4000 in 100's is there a quick way instead of

numseq = array ("100", "200", "300", etc etc)

these are names of worksheets within a workbook.

Many thanks

Ian

excel 2007

 

[IvenBach]

Will this help? http://www.youtube.com/watch?v=LRzB_Pd6a3k.

 

[IanWells]

Cant watch youtube videos they are blocked!!!!

 

[DonkeyOte]

A few methods

Sub Standard()
Dim lngArr() As Long, lngUpper As Long, lngStep As Long
lngUpper = 4000
lngStep = 100
ReDim lngArr((lngUpper / lngStep) - 1)
For lngi = LBound(lngArr) To UBound(lngArr)
    lngArr(lngi) = lngStep + (lngStep * lngi)
Next lngi
End Sub

 

[IvenBach]

A1 100
A2 =a1+100
Drag down to the number you need. In a column next to it highlight from B1 to the equivalent bottom of where the A column is. Should be B40. In B1 type an = sign then select A1:A40 and CSE control+shift+enter. That should copy the numbers. After you have that you hit F2 then F9 and you have your numbers and ctrl+C is it.