Macro to Sum

[erock24]

I need a macro that will sum the values in column P from P8:?
The trick is that my # of rows will vary. I have the macro ending in the right spot. So, if I have 90 rows of data my macro ends in P91. Now I need to be able to have it sum P8:P90. Like wise if I have 300 rows of data my active cell will be P301. I need P8:P300 summed.

Is this possible?

Thank you for your time and help.

 

[erock24]

Wow!!
That worked perfect.
Very cool!

I thank you very much.