Maybe...

ActiveCell.FormulaR1C1 = "=LEFT(R[" & YTDOrig & "]C[4],LEN(R[" _
& YTDOrig & "]C[4])-1)"



wrote:

I'm trying to place a formula in a cell but I don't have a constant
location of the row for the cell. See the code below as an exmple:

ActiveCell.FormulaR1C1 = "=LEFT(R[YTDOrig]C[4],LEN(R[YTDOrig]C[4])-1)"

How can I place a formula in a cell to achieve the results attempted
by this code in an allowable syntax?

Frank

--

Dave Peterson