Paste values only to visible rows

[alpharay]

Hi All,

I'm using VBA to copy and paste user selected cells from one workbook to another. The target workbook is filtered and I'm only pasting to the visible rows. The problem I'm having is I don't know how to make it so I'm only pasting the values. I don't want formulas, formats, etc. to be copied over to the target cells. It would be very much appreciated if you could add the fix to my existing code. I hope someone can help.

Please Login or Register  to view this content.

[mangesh.mehendale]

Hii Welcome to forum... Please update your code as per forum rule 3..

http://www.excelforum.com/forum-rule...rum-rules.html

[alpharay]

Done...Thanks

[mangesh.mehendale]

Combination of both http://www.mrexcel.com/forum/excel-q...ells-only.html and http://www.extendoffice.com/document...ble-cells.html

here is code as per you requirement

Please Login or Register  to view this content.

[alpharay]

Thanks for your time, unfortunately this code does not work for me. I copy say 5 rows and it pastes everything into one column in the target workbook. It also pastes all the formatting. I just want the values. My original code works great. I just need to make it somehow just paste values. Thanks.

[mangesh.mehendale]

Hiii Try this one which will paste only values

Please Login or Register  to view this content.

[mangesh.mehendale]

Hiii Try this one which will paste only values

Please Login or Register  to view this content.

[alpharay]

So yes, it's pasting only values now, which is great. But it's still pasting everything into one column. Also when my target workbook is filtered, it stops at the first hidden row. By the way, I'm using Excel 2013 version, which my have something to do with that. Again, if my original code could be changed to paste only values, it would be a perfect world. Thanks again.

[mangesh.mehendale]

I think your code not giving correct results... but if you want to go with it then try this

Please Login or Register  to view this content.

[alpharay]

Hi Mangesh,

Thank you for last response. The code works perfectly.

[alpharay]

Hi Mangesh,

Thank you for your last response. The code works perfectly.

[mangesh.mehendale]

If done mark this thread as solved see at top(in Thread Tools)...

Also hit on "Add Reputation" to the answer if someone help you in this forum....