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