Basically, I want to do the following inside a macro. The macro should
work on any selected cell, and can be used in many different
locations.

If I select C1 for example and run macro, I want the following change
made in D10:

Original D10: =F4+B5
New D10: =F4+B5+C1

I've figured out the following line of code to start with:

Range("D10").Formula = Range("D10").Formula + Selection.Cells(Row,
Column)

But it doesn't give me what I want.


--
craigjl
------------------------------------------------------------------------
craigjl's Profile: http://www.excelforum.com/member.php...o&userid=33247
View this thread: http://www.excelforum.com/showthread...hreadid=530719