I have a total line I have inserted into my spreadsheet.

The activecell in column A is offset by (0,2) to reach the destinatio
for the formula.

In that active cell I need to SUM the values of the cells reference
by
(1)

CODE
Selection.Find(What:="Committed Allocations Total", After:=ActiveCell
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext
_
MatchCase:=False).Offset(0, 2).Activate
and (2)

CODE
Selection.Find(What:="Committed Projects Total", After:=ActiveCell
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext
_
MatchCase:=False).Offset(0, 2).Activate

and (3)

CODE
Selection.Find(What:="Very Likley Projects Total", After:=ActiveCell
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext
_
MatchCase:=False).Offset(0, 2).Activate
and (4)

CODE
Selection.Find(What:="Unplanned Very Likely Total", After:=ActiveCell
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext
_
MatchCase:=False).Offset(0, 2).Activate

so I need to have the sum of (1)+(2)+(3)+(4) and then fill this acros
12 columns.

how can I acheive this?

thanks in advance..

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=48385