Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Assigns the values 101 to 200 to the range B1

Sub main()      [B1:B100] = [ROW(101:200)] End Sub