I have read posts about pasting a formula into a column that already has data
by using, for example:
Range("L2:L" & Range("L65536").End(xlUp).Row).FormulaR1C1 =
"=SUM(RC[1]:RC[38]"
This isn't working for me because my column does not have any data in it
(inserting the column is part of my code).

All the other columns in the spreadsheet have data, but not this newly
inserted column. Can anyone help me with pasting my formula into the column
only for the rows that have data?

Thank you for any help you can give me,
Judy