Simplified Example without a macro:
C11: =SUM($A2,B$3)
I can drag that formula so it fills the range C11:F15 and it maintains the relative referencing.

I need to be able to select a range of cells (C11:F15) and run a macro that enters the values returned by the function (=SUM($A2,B$3)).

I'm extremely new to Excel macros, but have many years of programming and scripting experience.

Thanks,
JC