Macro to Multiply Column A and B and Cell D5 and enter resul

[Cosmos75]

I have two columns (A & B). I need to have in Column C to product of A & B, i.e. I need A * B in C. But the entire formula is A * B * D5 in C. Also, the length of the lists in A and B varies. I need a macro to do this:

Start on A1
IF AND(A1<>””,B1<>””)
THEN C1 = A1*B1*D5
Goto A2
IF AND(A2<>””,B2<>””)
THEN C2 = A2*B2*D5


How do I do this?

 

[Al Chara]

So which is it? Do you want the value or the formula to appear in column C?

 

[Cosmos75]

I need to a formula to be entered and have the entered formula calculate the value. Sorry if I confused you. THANK YOU FOR ALL THE HELP!!