Inserting a forumla to entire row

[MR3]

How does one insert a formula and apply it to an entire column, say column C.

=sum(A1+B1)

 

[T. Valko]

How does one insert a formula and apply it to an entire column, say column C.

=sum(A1+B1)

If you wnat to get the sum of every cell in column C:

=SUM(C:C)

You can put that formula anywhere *EXCEPT* in column C.

 

[MR3]

i know that but i want to insert it in my vba macro.
so then it takes =sum but of the total number of used rows.

so for example, if i run a count and then i know that my worksheet has 13 used rows now in my macro i want it to apply =sum(b1) all the way down to =sum(b13) something along those lines

 

[BradleyS]

If your using a macro why not build in Ctrl+Shift+DownArrow as this will always take you to the last cell with data.

 

[MR3]

thanks BradleyS thats a good idea!