Simple Line of Code to enter a formula in the active cell using VBA
ActiveCell = "=Trim(RC" & 1 & ")"
I want this formula to mean Active cell = value of cell in active row, column 1
The formula that is being returned is relative both to column and row.
If i type the formula directly into the active cell. I.e Trim(RC1) it returns the correct answer.
What in the name of all that is VBA am I doing wrong. Wood, trees etc....