View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Load selection into an Array - VBA

Dim arr

arr = Range(Cells(1), Cells(10, 10))


RBS


"brittonsm" wrote in message
...
How do I take a selection of cells on the sheet and load them into an
Array in VBA?

-Steve