How to copy values

**kandre** · 03-21-2013, 05:01 AM

Hi,

I have 42 workbooks i want to copy values from a databank sheet. I,ve written a code that works through each workbook to copy the needed cells into a master workbook. The problem is that it copies references instead of values. The reference is to filepath+workbookname+cellreference. I want only the values. I,ve tried the paste special coding but it fails. Can anybody see where my mistake is?

Please Login or Register  to view this content.

**AB33** · 03-21-2013, 05:20 AM

Kandre,
I do not see any copy line in your code, except this line

Please Login or Register  to view this content.

Where are you pasting the copied values in to?

**HaHoBe** · 03-21-2013, 12:37 PM

Hi, kandre,

AFAIK you need not unhide the sheet to copy the data. Give this a try:

Please Login or Register  to view this content.

Ciao,
Holger

**kandre** · 03-21-2013, 05:56 PM

Hi guys and thank you for the posts. Need to clarify what I'm after. This macro copies and pastes from all the workbooks into a mastersheet. The problem is that it doesn't copy values. It copies the formulas that's in each of the cells of each wb.

**AB33** · 03-21-2013, 06:02 PM

But in which part of your code shows you are copying from area A to and pasting it to area B, assuming you posted the full code?

**kandre** · 03-22-2013, 02:19 AM

I have commented in the code.

With range - copies
.copy wsmaster - pastes

**HaHoBe** · 03-22-2013, 03:01 AM

Hi, kandre,

the sniplet I supplied doesn´t use Copy&Paste but should copy the values from one sheet to the other - any run time errors ocurring or values not being copied with that (code did good in quick samples to check)?

Ciao,
Holger