Please: how do I copy (in VB) only data and not cell formulas and such

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

newnew

Thread Starter
Joined
Jan 1, 2015
Messages
6
Hi Again everyone;

May I please ask for some additional help.

I wish to copy data (not cell formulas) from F115:K115.
I am "trying" to use the following VB formula;

Range(Range("("f115"), Range("f115").end(xltoRight)).Copy Range ("J10")

Actually, the above VB formula copies and puts something into the 7 cells to the right of J10, but it's all gibberish.

I see that I am copying a mish-mash of cell references and so forth, and not 'just' that data (the values) which are in these cells.

Would someone please tell me how to copy 'only' the values which are in cells (F115:K115) ...
Oh yes, the values in these cells (F115: K115) keeps changing (as I want it to do) but the data does remain in these cell locations.

As always, thank you for your help.
J.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,643
Hi J,
I assume you are talking about VBa and Excel (version (?))
If you want to copy a range of cells just do that.

You could even record the macro and see what it does.

Range("F115:K115").Copy
Range("J10")..PasteSpecial Paste:=xlPasteValues

You select the rannge you want to copy and then select the first cell in the target range and paste

Hope this helps, if not, I suggest you put some more information in your post, you know, we are quite good at helping but guessing and asuming, that's quite a different matter :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top