I'm trying to use VBA to insert a formula into in excel spreadsheet that contains file path
Snippit of the codes
Dim sdpath As String, sdfile As String
sdpath = "C:\Users\amcin\OneDrive\Work Ops\VBA Projects\Sales Report\"
sdfile = "Sales Report Data.xlsx"
Range("B" & lr).FormulaR1C1 =...