excel - function or syntax to copy/reference a cell value instead of a cell formula

Question

I would like to insert in a cell the value calculated by a formula in another sheet.

If I use the something like =MySheet!MyCell Excel adds a reference to that cell and by doing that it actually re-use that formula.

As only option I know I can use "Paste Value" to copy the value from that source cell to my destination cell.

Is there any Excel function to just copy the value or do I have to implement a function/marco myself?

Answer 1

In Excel function or VBA function you can only make reference to the cells. To "Paste Value" you have to write VBA sub.