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