Being in one cell how copy from other cell content

[LOMBARDI]

I have a formula on A1 = B1 + C1. I want to record a macro that being in any other cell of this worksheet copy the formula in A1 and stay in this same cell after the copy, always in relative way.
Sample: If I am in G10 and copy the formula I will get G10=H10+I10 and stay in the G10 or If I am in K20 and copy the formula I will get K20=L20+M20 and so on.

[Paul]

Hi Lombardi, and welcome to the forum.

Not sure why you would need a macro for this, but you could use:

Please Login or Register  to view this content.

[19fortysix]

LOMBARDI,

Here's one way to do what you want. Create a "named formula". Go to Insert>Name>Define and in the "Names in workbook" type a name for your formula, maybe "MyTotal" or whatever you like then click in the "Refers to" box and type =B1+C1 and click "Add".

Now press Alt-F11 to open the VB editor and then click Insert>Module and paste the following macro

Please Login or Register  to view this content.

When the macro runs it will sum the two cells to the right of the active cell.
Hope that's what you were looking for!
GMc