I'm trying to Sum various numbers of rows in a large worksheet. I need a
genric formula to sum the continuous rows of numbers above the total line
where the formula will be located. The number of continuous rows for each
instance will be different, therefore the need for the general reference or
generic formula. I've tried the Range(Selection, Selection.Offset(-1,0) and
ActiveCell.Offset (-1,0) and also the Selection(xlEndUp) codes but can't get
them to produce the Sum function correctly. I can copy and repeat the code
throughout the worksheet if only I can figure out how to do the first one.
Help please. I've tried to doulbe click the Sum button but it gives me the
specific range at the time and is not usable on other rows farther down in
the worksheet.
--
Mickey