Hi all
I am trying to input a formula (=A!E15) into Range("B4")
There is some issue with the VBA formula .
Kindly advise.PHP Code:
Sub Formula()
Sheets("A").Select
Range("E" & Rows.Count).End(xlUp).Select
CellAddress = ActiveCell.Value
Sheets("Summary").Select
Range("B4").Formula = "='A! & CellAddress'"
End Sub
Bookmarks