Adding a = sum formula to code

[Steve001]

Hi all

Bit stuck, want to look at my sheet and add a = SUM calculation I am using last command to find the last row

last = Cells(Rows.count, "F").End(xlUp).Row

so how do I put into my sheet ?

=SUM(G2:last row)

hope this makes sense

ps please put comments on the example as I am still finding my way round vba

Steve

 

[JackDanIce]

Try:

last = Cells(Rows.Count, 6).End(xlUp).Row
Msgbox last
Msgbox "G2"
Msgbox "G2:G"
Msgbox "G2:G" & last
Cells(1, 1).Formula = "=SUM(G2:G" & last)"

Then edit as required.

NB: A1 = row 1, column 1, F7 = row 7, column 6 so Cells(1, 1) = Range("A1"), Cells(7, 6) = Range("F7") etc

 

[Steve001]

cheers Jackdanice

Will have a go

Steve

 

[Steve001]

Working thank you

Steve

 

[JackDanIce]

You're welcome