Need VBA macro to copy cell contents instead of its formatting

Dear All,

I'm in need of a VBA macro which copies a particular cell value to clipboard without copying its other cell formats like cell color, border etc.,

Below is my problem in detail.

Daily at my work, I use an application in which i need to copy a cell value(Say: 123456), but it wont accept the value if i just copy entire cell and paste. To copy that cell value(123456) into that application, I have to select that cell where i have that value(123456) -> press F2( or copy the cell value(123456) from formula bar) -> double click on the value(123456) to select and copy entire value(123456) in that cell.

I tried below macro but it is not meeting my requirement, as it is copying entire cell instead of just cell value.

Please Login or Register  to view this content.

Any help will be grateful.

Hi, Nanimadhu,

please wrap your code with tags as requested by Forum Rule#3.

Maybe something like this:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Nanimadhu,

my bad - I thought I had set a hint about that into the code. You will need to set a Reference in the VBE to Microsoft Forms 2.0 Object Library in order to get the code working.

Ciao,
Holger