Quote:
Originally Posted by macropod
Just how is a Worksheet_Change Event supposed to input the required number, which the OP has yet to indicate either where it is to be found or how it's variable value is to be determined, into the formula? Until both those issues are resolved, no solution is possible.
|
The hope is that although the OP has not learnt enough to describe this impractical assignment clearly, the intent is to enter data in the F column followed by entering data in the G column. In the Worksheet.Change code the product of F and G will replace the value in G.