Thread: Dynamic Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gian Gian is offline
external usenet poster
 
Posts: 15
Default Dynamic Range

I would like to sum up some values within the cells for each loop,like A1..A5
when i = 1, B2..B6 when i=2 etc., I know I can not put the cell variable into
the Range() property. Are there any other way to do this? Please help.