Copying Values and Formatting without Copy/PasteSpecial

Hi all,

I've written VBA code to loop through some data and paste the values and formatting into another sheet, and while it works okay, it has to go through a huge amount of data so I'm trying to eliminate the copy/pastespecial step to speed up the code.

Is there a way to write a code like:

Example

Please Login or Register  to view this content.

that will copy the formatting along with the values?


Here is the code I currently have written:

Please Login or Register  to view this content.

Thanks for your help.

Chris

Hi Holger,

Thanks for the response. I tried your code and while it does copy the values over, the formatting changes slightly (# of decimals etc) and I also lose conditional formatting I have on the original cells. The code also pastes each new line of data on top of the data it just pasted in.

Any other thoughts?


Thanks,

Chris

Chris

Slightly off topic, but have you considered using a filter to get the data you want then copying it in one go?