Trouble writing a macro to insert a sum formula with variables into a cell

[kmarshall6576]

I'm new to macros and trying to write a formula within a macro for the first time. I have a large range of data. The number of rows of data will change each time I use the file. The columns could change as well. At the bottom of the data there is a total line but the formula breaks in a sort that I do earlier in the process. I use cells.find to get the row and column numbers for the total line. I am trying to use the variables that come from the cells.find to create my formula but it isn't working right. The result I get in my file is a formula of =sum(359:352086) and the result is #DIV/0!.

I'd like to sum all of the data in the column from row 9 to the line above the total row.

HELP PLEASE!

Please Login or Register  to view this content.

THANK YOU SO MUCH FOR YOUR TIME!

[rcm]

I think that sum() needs reference of a range (col&row) and not only numbers..

[kmarshall6576]

Thanks for responding to me question. I'm not sure I understand though. I define the variables as row and column numbers first and then try to pull them into the formula. Is that possible?

THANKS!!

[kmarshall6576]

I think I figured out what you mean. My variable find column 35 and row 2086 so it is putting this formula into the cell:

=SUM(359:352086) and giving me the error as the result.

I think I need to figure out how to do this with R1C1. UGH!