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.
|