Multiply a Cell by a named range

[pearl]

Hello,

I have to a defined range and would like to multiply it by a cell that is on another worksheet. I'm not sure where to begin.
<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> Jancost <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Currency</SPAN><br><br>ActiveCell.FormulaR1C1 = Jancost * "=+(1-RC[-1])"</FONT>

I've tried this and also nameing the cell next to it, it is in a percentage form and does not calculate properly. any suggestions?
thanks,
Pearl

 

[pedie]

Something like this?
Change sheet name

[/FONT]
[FONT=Courier New]Option Explicit[/FONT]
[FONT=Courier New]Sub multiply()
Dim Jancost As Integer
Jancost = 2
Range("D2").Value = Format(Jancost * Sheets("FutureHirings").Range("C2").Value, "$#,##0.00;($#,##0.00)")
End Sub

 

[Dryver14]

Pedie JanCost is a named range

What does the range consist of?

If this range is constant and the numbers within it change then it may be worth just placing another column on the sheet it self and multiplying it on the page by what i assume to be a changing percentage

 

[pearl]

What I'm trying to do is multiply 12 months by a percentage that the user enters and place this total in the next cell. The months are on different sheets which is why is needs to be a range name. I tried making the pecentage a range name also. When I tried to write

activecell.value = jancost * costpercent

it didn't work. It recogninzes jancost by itself and costpercent by itself but not when multiplied together. costpercent is entered as percentage on the spreadsheet.

any ideas thank you,
pearl

 

[pearl]

I've have it to where I can multiply the pecentage by the cost however, the percentage can't in be in the percentage format. It has to be a whole number. Is there any way to multiply a percentage by a currency?