I have a code below where when I run it gives me a Runtime error 9 sub script out of range error. The code works, but it still gives me that error. Does that mean the VBA code cannot locate the csv file mentioned on the debug row? Thanks in advance.
Sub Price() 'Price Macro Columns("C:E").Select Selection.Delete Shift:=xlToLeft Range("A1").Select ActiveCell.FormulaR1C1 = "Ticker" Range("B1").Select ActiveCell.FormulaR1C1 = "CustomTradePrice" Columns("B:B").Select Windows("mBOSExport%20OCM%20Daily%20Prices%20##20110706.csv").Activate <= debug problem Windows("Prices.csv").Activate Range("C1").Select End Sub