I have a macro (Conversion) that runs when a specific cell, say "F6" is
changed from a blank cell to a given value using a dropdown box. The macro
does a conversion based on the choice, and puts the answer in "H6".
Obviously, to make it work for the whole sheet (down each row), I need to
pass the row value to the macro, but I'm drawing a blank as to how to do
this. I know this is probably an easy one, but could someone please help me?