copying cell without removing formula from the cell i copied from

as stated in the title is there a way to copy a cell which has formula in it, copying the the cell as a value is fine but i want the copied cell's formula to remain. =/
is it possible ?

and is it possible to have a formula in cell plus have an operating macro in the same cell ?

thank you

awky dowky! the first one got solved! how stupid of me, i forgot the to assume that copying a cell which has formula in it into a noteped was the answer im looking for!

and about the second one its i fixed the problem i took a different approach on my project it worked, dont wanna get into details lol my head hurts from these macro's im trying to learn :P

anyway thx!