Basic Formula to Button

[wayne0881]

Hi All,

I have a formula that returns the last text cell which is =INDEX($F$6:$F$13,MATCH(REPT("z",255),$F$6:$F$13)) and it works well.

How do I go about adding that same formula to a form control button?

do I use ActiveCell.Formula?? along with my =INDEX($F$6:$F$13,MATCH(REPT("z",255),$F$6:$F$13)) somehow??

Thanks in advance

 

[Michael M]

Do you mean....assuming Range("A1") to be where the formula needs to be placed !

Range("A1").formula="=INDEX($F$6:$F$13,MATCH(REPT(""z"",255),$F$6:$F$13))"

 

[wayne0881]

Exactly that!

Thanks