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

If you are already copying down by hand in the sheet then you could
simply copy the selected cells once you have copied down and move over
one column and paste special as values.

Or do you want a macro to both copy the formula in one column and then
paste the values into the rext column?


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