I'm currently adding a formula to a specific cell using Range("C2").Formula = "=VLOOKUP(B2,Test,{2,3},0)", however, when I check the cell after using my sub(), it shows
=VLOOKUP(B2,Test,@{2,3},0). Where is this @ symbol coming from?
Asked
Active
Viewed 23 times
0
Jack
- 119
- 1
- 10
-
`Range("C2").Formula2 = ...` – Scott Craner Dec 20 '21 at 21:37