Help with Function Error

[wtsabo]

I'm simply trying to create a formula that I have been typing manually.

The formula typically looks like this:
=INDIRECT($B5&"!"&C$1&$F$2)*$H$2

I tried the VBA code:
Function Figure(Name, Column, Row, Multiplier)
Figure = INDIRECT(Name&"!"&Column&Row)* Multiplier

End Function


Any ideas to what I'm doing wrong?

Thank you

 

[Jonmo1]

Try
=INDIRECT($B5&"!"&"C$1&:F$2")*$H$2

 

[njimack]

Surely it would be something like this (untested)

Function Figure(Name As String, Column As Long, Row As Long, multiplier As Variant)

Figure = Sheets(Name).Cells(Row, Column) * multiplier

End Function

 

[wtsabo]

Neil,
I think that's close but still receiving an value error.

I tried with no luck
Function SubsidiaryFigure(SubsidiaryName As Variant, Column As Variant, Row As Long, multiplier As Integer)
SubsidiaryFigure = Sheets(SubsidiaryName).Cells(Row, Column) * multiplier
End Function