• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to format paste special values

Hi,


Try the below code:


Sub pastevalue()

Range("c1").Select

Selection.Copy

Range("d1").Select

Selection.PasteSpecial xlPasteValues

End Sub


It will copy the value from C1 and paste in D1 with value.


Thanks,

Suresh Kumar S
 
Hi Suresh,


I need the macro to execute based on cursor selection of cells. That means, i will select certain number of rows and only for that rows, copy paste special values need to perform
 
Hi Sree,


Coping multiple values and pasting as values is not possbile.


Can you please down the below file:


http://www.2shared.com/document/e4iShaxb/Book4.html


Sheet1 is values and sheet2 is forumla.

Go to Sheet2 and select any one of the value and press Control+q it will copy and paste as paste special values.


Thanks,

Suresh Kumar S
 
Hi Suresh,


Thanks. I need the same requirement based on multiple selection of cells.

Means, i select multiple ranges and then try clt+q , then it has perform paste special values.


regards

Sreejesh
 
Hi Sreejesh,


Sorry I tried but i am not able to make it possible may be any Excel Ninja can solve this.


Thanks for your feedback.


Thanks,

Suresh Kumar S
 
Dear Sreejeshc,

I am not sure, multiple selection area can be copied and pasted special value by macro, it is possible or not.

But according to your first requirement, Suresh's solution is perfect.


Regards,


--Muneer
 
Hi Sreejeshc,


Can you please try the below for me..

[pre]
Code:
Sub PasteSpecailValue()
Dim Area As Range, Cell As Range

For Each Area In Selection.Areas
For Each Cell In Selection
Cell.Value = Cell.Value
Next Cell
Next Area
End Sub
[/pre]
Regards,

Deb
 
Back
Top