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)

Hi
if A2 is a real date value try:
=C6*MONTH(A2)

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff wrote:
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)