ActiveCell.Formula incorrect value

[khalid79m]

Please Login or Register  to view this content.

i need the fomula to sum up c1:c & lastrow but this doesnt work, it just puts "C1:C4" into the cell

[Leith Ross]

Hello khalid79m,

You left out the SUM function, and using "C1 to last row" isn't R1C1 formula style. Stick with A1 style when writing macros. You rarely need to select cells when writing macros in VBA.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[royUK]

Does this help?

Please Login or Register  to view this content.

[khalid79m]

Very useful . Thanks Mate