I am trying to replace the date “07-29-2024” with the return value from INPUTBOX.
From This:
ActiveCell.FormulaR1C1 = “=IFNA(VLOOKUP([@Column1],’07-29-2024′!C[-5]:C[-1],2,FALSE),””NEW””)”
To This:
Tab_date = InputBox(“Enter Prior Release Date:”)
ActiveCell.FormulaR1C1 = “=IFNA(VLOOKUP([@Column1],&tab_date & !C[-5]:C[-1],2,FALSE),””NEW””)”
I have tried various combinations of & ‘ “.
5