You'll want to select your start/end column, search through the cells until
the value is "START" and then save that row number as your start row. Do the
same for "END" and save that as your end row. Then sum in your data column
from startrow to endrow.

"Thyagaraj" wrote:


wrote:
Whoa...that doesn't make any sense...What are you trying to do and what
is this macro suppose to do?


Thyagaraj wrote:
Dear Friends,

I need to sum a particular range of cells in a macro which is in
between the excel sheet.

But there is a word start just above the previous cell where the data
should start and the sum should happen till the activecell.



Can any body help

Thanks in advance

Regards
Thyagaraj

Dear Shaka,

Suppose a word "start" is present on cell A1 and a word "end" is
present on the cell F1 then cell G2 should be the sum of A2 to F2.
( Here words "start" and "end may be any where on the sheet.)
the sum of the middle data between "start" and "end" should be used in
a particular macro.

Can any body help.................!

For any queries revert.

Thanks in advance

reg
Thyagaraj