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>
To: ExcelVBA@yahoogroups.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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
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
----------------------------------
Tidak ada komentar:
Posting Komentar