Thread: Keep Same Range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
  
Posts: 410
Default Keep Same Range
Thank you dave and Max. The indirect works great. I forgot to add
the quotes. So it was Sumproduct((INDIRECT(A1:A1000)*.... instead
of ...INDIRECT("A1:A1000")....
Thanks again,
Jay

Reply With QuoteReply With Quote