View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Whelchel Jim Whelchel is offline
external usenet poster
 
Posts: 1
Default store cell contents and cell address for comparsion & suming

I am trying to in my macro to compare the GL acct #'s in the account column
and on change sum the amounts, using stored range adresses, in total column.

So i need to know how to store and compare cell contentsand cell addresses,
and then how to use the stored address in a sum sttement.