Paste special code

**Lazypanda** · 11-20-2008, 07:05 AM

Hi all,

I have a vba code that does everything I want except one thing - is pastes the data, however i need it to paste special the data as the range that i want to copy has formulas.

What the code is suppose to do is copy a range of data from one sheet and paste special it in the next available blank column in another sheet.

The code i have is as follows:

Please Login or Register  to view this content.

If anyone can help me adjust this code so it paste special the value instead of a normal paste i would be greatful.

**royUK** · 11-20-2008, 07:21 AM

Please read the Forum Rules & use correct Code Tags.

**royUK** · 11-20-2008, 07:24 AM

I it pasting over the formulas?

Why do you need to move the data, your formulas can reference data on another sheet?

**Lazypanda** · 11-20-2008, 07:38 AM

I need to paste special the range as it contains formulas. If i reference it as you have suggested then my file becomes very big and i need to keep the file as small as possible.

**royUK** · 11-20-2008, 07:45 AM

I still don't follow what you mean by pastespecial, do you want to change the formulas to values?

**Lazypanda** · 11-20-2008, 07:58 AM

Sorry for not being clear.

Range AD4:AD7500 includes formulas - I need the code to copy this range and paste the values into another column.

**royUK** · 11-20-2008, 08:29 AM

Is this right

Please Login or Register  to view this content.

**Lazypanda** · 11-20-2008, 11:16 AM

Hi royuk,

I have tried the code you suggested but it makes no difference - it still copies the formulas instead of the values.

I have attached the file I am working with which also includes the vba code - this should help you understand the problem I am having.

Thanks for your help.

**royUK** · 11-20-2008, 11:27 AM

Your source sheet7& target sheet are the same, you are copying AD4:AD7500 - most of which is empty. The formulas are in AE, so are not copied

**Lazypanda** · 11-21-2008, 05:34 AM

My file was to big to attach so i edited the file to reduce the size hence the reason why there is data missing.

Data in fact will be copying column AE - I made the mistake of copying AD.

Can you help me to edit the code so it copied the values of column AE?

Thanks for your replies.

**royUK** · 11-21-2008, 05:47 AM

This will copy AE to the column as values

Please Login or Register  to view this content.

**Lazypanda** · 11-21-2008, 07:22 AM

Thank you very much royuk, this works perfectly! Thanks again!

**royUK** · 11-21-2008, 07:51 AM

please mark the thread solved & rate the answer

Paste special code

LinkBack

Thread Tools

Rate This Thread

Display

Paste special code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions