you could use the sheet double click event for example to switch from
formula to value?

"Alfredo_CPA" .(donotspam) wrote in message
...
This is not something will save a lot of time, but I'm just trying to be
more
familiar with VBA.
I'm wondering if there is a way to have a macro that stores a formula for
a
while (like an activate button) then another macro that paste the formula
in
selected cells and finally an "exit button" to stop storing that formula.
I.e. I have a formula in c1 thatI will be using when analizing data. Once
I'm in C500, I know I need to paste that formula and i don't want to
scroll
up to go and copy and then paste, instead I want to click a cutom buttom
to
paste that formula. (it is possible that i copy and paste other things
before
arriving to cell C500 so the "Application.CutCopyMode" will be false by
then)
The formula is perfectly relative to the new cell - then no problem with
wrong references
Any Ideas??
Thanks


ws