Re: [ExcelVBA] Code

And then, Claudia, you can edit your recorded macro to only include the paste bit by putting an apostrophe at the start of the copy line to make it a comment. Assign a shortcut key to the macro, like CTRL-D for paste special values only. It falls naturally for the left hand in terms of cut, copy and paste.

Regards

Paul V

Sent from my iPad

On 17/05/2013, at 0:01, "Paul Schreiner" <schreiner_paul@att.net<mailto:schreiner_paul@att.net>> wrote:



Claudia: Welcome!

If you're wanting a VBA macro that does the Copy/Paste Special,
then the easiest thing to do is to record a macro that does exaclty that.

You MAY need to turn on the "Developer" tab of Excel.
(This is done different ways, depending on the Excel version you're using)

Next, Select to Record a macro, (give it a name like: "PasteVals")
If you want the macro to be ONLY in this workbook, then select it to save to
this workbook. If you want it available in any workbook you have open, save it
to your Personal.xls (or Personal.xlsb) file.

Then, select your range (or column) Copy and Paste Special Values.

Stop Recording.

Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------

________________________________
From: darkroom3717 <cmendoza@fellowes.com<mailto:cmendoza%40fellowes.com>>
To: ExcelVBA@yahoogroups.com<mailto:ExcelVBA%40yahoogroups.com>
Sent: Thu, May 16, 2013 11:45:28 AM
Subject: [ExcelVBA] Code


Hello My name is Claudia and it's my first time emailing this group.

I'm working off 2 spreadseets - one that has a vlook up and what I need help
with is changing those cells to paste special values - is there a code I can use
as macro.. FYI: These cells are all over in row order.

Thank you

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]



------------------------------------

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ExcelVBA/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ExcelVBA/join
(Yahoo! ID required)

<*> To change settings via email:
ExcelVBA-digest@yahoogroups.com
ExcelVBA-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
ExcelVBA-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/