LSB,

Range("Brokerage_Commission")
should do it.

Example:

Say Brokerage Commission = .05
In cell A1 (on the active sheet) you have 150

Sub TestMe()
MsgBox Range("Brokerage_Commission")*Range("A1")
End Sub

John

LSB wrote:

I am trying to work on some calculation in my macro. I
have named one the cells as "Brokerage_Commission" in, in
my Macro I would like to get this value to multiply with
another value. How can I refer the "Brokerage_Commission"
in my macro. The Brokerage_Commission is in different
worksheet as I want to put the result in another worksheet.

Please help.

Thanks.