VBA formula in a cell

[andrewb90]

Hello everybody,

I have this in my VBA:

ActiveCell.FormulaR1C1 = "125"

I would like to instead of typing a preset value, I would like to use whatever is typed in cell: "Info!E11"

Is this doable in VBA?

Thanks,

 

[Firefly2012]

Try:

ActiveCell.FormulaR1C1 = Sheets("Info").Range("E11").Value

 

[VoG]

Or

ActiveCell.Value = Sheets("Info").Range("E11").Value

 

[andrewb90]

awesome! thanks