Hey folks,

(Excel Noob here)

I need to give certain cells a formula through code. I need it to grab the
formulas from another Excel spreadsheet's cells. I think I'm pretty close
here, but the following errors out. Do you see what's wrong?

For i = colStart To colEnd
ActiveWorkbook.Worksheets("MyWorksheet").Cells(i, rownum).Formula = "='"
& otherExcelFilePath & "'!OrigSheet:$A" & CStr(i)
Next i

So I want the cells in row rownum from cols colStart to colEnd to contain
the formulas in the other Excel spreadsheet. The other Excel Spreadsheet
should use it's worksheet OrigSheet, row A, cols colStart to colEnd.

Thx!