Macro for copying the value of a cell to the clipboard

[MartinCarlsson]

Hi
I need a macro that copyis the value of a cell, with a formula, to the clipboard.

Say,
A1 contains: "=B1+1"
B1 contains: "10"

The macro should be able to copy the value of A1 so the clipboard contains "11".


Martin

 

[MartinCarlsson]

Does anyone know how to do this?

 

[MartinCarlsson]

I've been working on this forever... and I have to say, I need an expert here

 

[vds1]

Why would you want to copy the data into clip board ?

 

[MartinCarlsson]

Why would you want to copy the data into clip board ?

I need to use it in another program ... that don't accept formatting.

 

[MartinCarlsson]

[SOLVED] Macro for copying the value of a cell to the clipboard

Add Microsoft Forms 2.0 Library i Tools > References

Sub PutCellValueInClipboard()
Dim MyData
Set MyData = New DataObject
MyData.SetText ActiveCell.Value
MyData.PutInClipboard
End Sub

 

[RoryA]

Re: [SOLVED] Macro for copying the value of a cell to the clipboard

Thanks for posting your solution. Can you please avoid posting duplicate questions in future?

 

[MartinCarlsson]

Re: [SOLVED] Macro for copying the value of a cell to the clipboard

Thanks for posting your solution. Can you please avoid posting duplicate questions in future?

Yes. I was afraid that my other post was too poorly written...

In the future I will post a "clarification" post in the SAME thread.

 

[RoryA]

Re: [SOLVED] Macro for copying the value of a cell to the clipboard

Thank you.