Hi,
Can anyone explain why the formula I enter into my VBA code for a cell is inconsistent.
For example the code I have is:
ActiveCell.Formula = "=FILTER('Live Data'!J:J,'Live Data'!M:M=" & Chr(34) & EventNo & Chr(34) & ")"
Fairly simple, and it works fine, but when I run the code the formula entered into the cell is:
=@FILTER('Live Data'!J:J,'Live Data'!M:M="EV9")
There is an @ at the start which prevents it from auto filling with the entire list. I have written the formula out to a variable after and it looks fine, so I have no idea where the @ is coming from. I have tried to use replace to get rid of it but it's not working.
Cheers.
Can anyone explain why the formula I enter into my VBA code for a cell is inconsistent.
For example the code I have is:
ActiveCell.Formula = "=FILTER('Live Data'!J:J,'Live Data'!M:M=" & Chr(34) & EventNo & Chr(34) & ")"
Fairly simple, and it works fine, but when I run the code the formula entered into the cell is:
=@FILTER('Live Data'!J:J,'Live Data'!M:M="EV9")
There is an @ at the start which prevents it from auto filling with the entire list. I have written the formula out to a variable after and it looks fine, so I have no idea where the @ is coming from. I have tried to use replace to get rid of it but it's not working.
Cheers.