Thread: VBA Code to enter formula in CELL

Hello
I wanna be able to click the button and the following code will be entered into cell B1

currently I am using this code,
for this code it is ActiveCell only if I am clicked on E29 it will write the formula in E29 but I want it like if I click the button or run Macro it will put the formula in B1

Sub B1Macro()
ActiveCell.Formula = "=PISampDat(COUNTER!$C$3,COUNTER!$A$7,COUNTER!$A$9,COUNTER!$A$11,0,""dmspi2p"")"
End Sub

ty

zit1343,

Change ActiveCell to [B1]

Sub B1Macro()
    [B1].Formula = "=PISampDat(COUNTER!$C$3,COUNTER!$A$7,COUNTER!$A$9,COUNTER!$A$11,0,""dmspi2p"")"
End Sub

Hope that helps,
~tigeravatar