Hey,

I need a statement to put in a macro that will find two cells and sum
them putting the result in cell d4. The first cell is always d7 but the
second cell moves about every time the data is updated.

I'm at a bit of a loss as to how to find the second cell, it is always
3 to the left of a cell named sales so I thought I may be search for
the cell 'sales' and then use then use offset to get the cell 3 to the
left and then define a name for it so I could use it in the sum... but
this doesn't work as it gives the cell a reference rather then calling
it active.cell.

Can anyone this of a way of doing this? As I am a wee bit stumped.

Cheers

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=542085