Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Formula multiplying ActiveCell with "F11"

  Asked By: Valera    Date: May 23    Category: MS Office    Views: 992
  

Hello,

I need a formula, that is multiplying selected cells number (ActiveCell) from the number that is in, for example, in range F11.

Tried the simple one:
ActiveCell.FormulaR1C1 = "=RC*F11"

But excel doesnt understand "F11" and show error or 0. Maybe its more complicated than i could wanted.

Than it would be good, if the ActiveCell after calculations would be the Cell down for the cell i multiplied. But its not necessary.

Thank you.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Valera Vai     Answered On: Jun 06

will help myself :DD

Selection.Copy
ActiveSheet.Paste Destination:=Range("E11")
a = Range("E11").Value
b = Range("F11").Value
ActiveCell.Value = a * b
Range("E11").ClearContents

 
Didn't find what you were looking for? Find more on Formula multiplying ActiveCell with "F11" Or get search suggestion and latest updates.




Tagged: