Thread: Array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JS[_4_] JS[_4_] is offline
external usenet poster
 
Posts: 14
Default Array

hi

this will create an array for Range("B4:I4")

Sub Test()
Dim rng As Variant
rng = Range("B4:I4")
End Sub