Hello,
I have tried to substitute "Xlookup" via VBA.
The code is like follows.
When I input this formula manually, it spilled in the way I wanted. However I run above code, A2 has "=@XLOOKUP(A1,Data!$1:$1,Data!$2:$100) " and 3rd and subsequent lines are empty.
"@"s are automatically included in the formulas.
When I manually remove the "@" mark after the macro, all formulas from A2 to O2 will be spilled correctly.
How can I block these "@" s in each cell with VBA?
Any help is greatly appreciated.
I have tried to substitute "Xlookup" via VBA.
The code is like follows.
VBA Code:
Range(Range("A2"),Range("O2"))).Value = "=XLOOKUP(A1,Data!$1:$1,Data!$2:$" & LastRow & ")""@"s are automatically included in the formulas.
When I manually remove the "@" mark after the macro, all formulas from A2 to O2 will be spilled correctly.
How can I block these "@" s in each cell with VBA?
Any help is greatly appreciated.
