View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
br549 br549 is offline
external usenet poster
 
Posts: 13
Default ranges as arrays

Is there a problem with:

Dim block(101) as Range

I've also tried block(), block(101), and still get object variable error
messages that point to the first time I try to assign the range block(i).
In my worksheet I have blocks of data of some 50 lines where the data in the
block is from a common date. I have operations I want to perform on each
block of data as a block. My idea was to define each block of common date as
a range, do my calculations on the block, then iterate to the next date code.