I am trying to assign a forumla in Excel 365 using VBA but run into something that I don't quite understand....
ActiveCell.Formula = "=Unique(A3:D" & LastRow & ")" ' I wanted to do this
ActiveCell.Formula = "'=Unique(A3:D" & LastRow & ")" ' at the end I use this then I delete the '
so, the first formula gets put into my cell, but it contains this symbol "@", because of that symbol, I only have one cell. As soon as I delete the symbol, my whole range appears??!! So, I did the second way to avoid that problem and works.
so, why is Excel putting that symbol into my formula and yet, it does not give me what I want.... How does one overcome this quirk to make it work?