Macro paste special part row based on cell value

**uncleslinky** · 03-15-2011, 04:00 AM

Hi there

I have the following code which paste special all rows where column F is "Y"
Is there a way this code can be changed so that only columns A - F are 'paste special vaules'

Please Login or Register  to view this content.

Thanks

**pike** · 03-15-2011, 04:24 AM

Hi uncleslinky,

You can use more with statements to make the code run quicker

Please Login or Register  to view this content.

**royUK** · 03-15-2011, 04:24 AM

Try this

Please Login or Register  to view this content.

It might be faster to use AutoFilter depending on the data layout.

**davesexcel** · 03-15-2011, 04:34 AM

Try this

Please Login or Register  to view this content.

**uncleslinky** · 03-15-2011, 04:46 AM

guys, thats great thanks!!

**pike** · 03-15-2011, 04:49 AM

the only left out was resize

Please Login or Register  to view this content.

**royUK** · 03-15-2011, 04:51 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save