Copying Cell Values

[crabtrees]

I'm currently using a macro:

Sub copyvalue()
With Sheets("Capacity")
Range("O14").Value = .Range("BM4").Value
End With

End Sub

But I'm very interested in getting any help to upgrade this to a
function so that I do not have to run the macro to get the value copied
from BM4 to O14.

I appreciate your help in advance.

 

[Dave Peterson]

Check your other post.

I'm currently using a macro:

Sub copyvalue()
With Sheets("Capacity")
Range("O14").Value = .Range("BM4").Value
End With

End Sub

But I'm very interested in getting any help to upgrade this to a
function so that I do not have to run the macro to get the value copied
from BM4 to O14.

I appreciate your help in advance.

 

[crabtrees]

Sorry...I need to keep the reference out of the cell so that it can't b
written over.

Thanks

 

[Dave Peterson]

Then I don't understand why you can't use the subroutine.

If you can't use a built in formula, I would expect that you wouldn't want to
use a user defined function.