I have a worksheet with three columns: account number, debit & credit.
For one range of cells I would like to build a macro that if there is an
amount in the credit column, to cut it and paste it to the debit column
and multiply it by -1. For another range of cells I would like to build
a macro that if there is an amount in the debit column, to cut it and
paste it to the credit column and multiply it by -1. I hope someone can
help me.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!