Hello everybody, I'm pretty new with the VBA things and I'm trying o do something special. I'll try to explain.

I'm doing a calculation and when a button is pressed I want to save that number in Sheet2. But the previous savings also have to be saved.
So I have done a calculation, I press a button to save it in A1 on Sheet 2.
I'm doing a new calculation and I press again the button to save it. But I don't want the number in A1 to be lost, so I want that the macro automatically searchs for the next free cell.
How can I do this?
Do I also have to include the fact that only the number and not the formula has to be saved?

Thanks
IVY440