Hi,

Is it possible to design a VBA Macro to execute the following?

I have in C6-C76 currency values.

I'd like to have these values to be multiplied automatically by the month of
the year located in A2.
Ex: C6 = $168.92
Ex: A2 = Nov-04
I'd like to have C6 * 11 or C6*12 (If A2 =Dec-04)