hi arnel. what is the activecell for? arent' you already specifying you want the formula inside cell A3? and when you do two equals like this below, it is doing a logical test:
ws.Range("A3") = ActiveCell.FormulaR1C1
it will return TRUE or FALSE. you are asking if ws.Range("A3") is equals to activecell.formular1c1.
secondly, if you use FormulaR1C1, you must use the R1C1 style. that is:
that means to refer to 1 row below A3 in the same column (A), and 1 row below A3 and 1 column after (B4).
if you wish to use A4,B4, use:
Bookmarks