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


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=379833