How would anyone know?

--
Regards,
Tom Ogilvy

"Dustin" wrote in message
...
You are right, it works just fine!
I just had to change the column numbers 4 and 3 in my case!

"JE McGimpsey" wrote in message
...
In article ,
"Dustin" wrote:

My question is how do I define the range of appropriate cells? and how
do I
run the macro? (I would like it to run automatically, invisible to the
user)

The macro will run automatically if you put it in the worksheet code
module (right-click the worksheet tab and choose View Code). When a
value is entered in column 1 or 2, the calculation takes place and the
result put in column 2 or 1.

The code's already set up to work on the "range of appropriate cells"
specified in your example - it will work if a value is entered in
Columns 1 or 2 (A or B).

What range are you looking for?