VBA Formula Issue

[VbaHell]

Hello All, I am using Excel 2007

I am trying to find where my last column is and then add a formula starting at "C5" and then adding this formula to all the columns
Is this possible please

LC = .Cells(1, .Columns.Count).End(xlToLeft).Column

With Range("C5" & LC)
.FormulaR1C1 = _
"=SUMIFS('MIS - Customer Invoice'!C11,'MIS - Customer Invoice'!C42,R[-2]C,'MIS - Customer Invoice'!C21,R6C2)"
.Value = .Value

End With

 

[Michael M]

try

With Range(Cells(5, 3), Cells(5, lc))
.FormulaR1C1 = _
"=SUMIFS('MIS - Customer Invoice'!C11,'MIS - Customer Invoice'!C42,R[-2]C,'MIS - Customer Invoice'!C21,R6C2)"
.Value = .Value

 

[VbaHell]

Hi Micheal

Thanks for the quick reply.
I am getting a compile error on LC = .Cells(1, .Columns.Count).End(xlToLeft).Column

Invalid or unqualified reference.

Is this piece of code correct for looking for the last column

LC = Range("A" & Columns.Count).End(xlToLeft).Column

 

[Michael M]

Remove the periods

LC =Cells(1, Columns.Count).End(xlToLeft).Column

 

[VbaHell]

Michael

Works a treat

Thank You