Paste value on filtered cells [Solved/Closed]

Question

Paste value on filtered cells [Solved/Closed]

Report

ehlblackstar

Posts: 12
Registration date: Monday April 5, 2010
Status: Member
Last seen: November 2, 2018

- Updated on Nov 1, 2018 at 05:49 AM
Blocked Profile - Nov 2, 2018 at 04:05 PM

Hello,

i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells...
im using a "=concatenate" on several cell, and pasting its value on another cell using "paste value". (this is on a filtered cells) But every time i remove or select all filtered cell. the copied cell was pasted on all cells. is there an easy way on pasting only the value on a filtered cells? FYI I'm using only 1 sheet for this

Paste value on filtered cells
Macro copy and paste in next blank cell - How-To - Excel
Macro copy and paste in next blank cell ✓ - Forum - Excel
Macro that goes to next blank cell ✓ - Forum - Programming
Copy and paste only non-blank cells with vba code ✓ - Forum - Excel
Vba copy data from a range and paste to empty column - Forum - Excel

1 reply

Ask a question

Blocked Profile · Accepted Answer · 2018-11-01T17:17:56-0400

Answer 1 / 1

Blocked Profile
Nov 1, 2018 at 05:17 PM

Check to see if the cell is filtered (it is a BOOL value) with the "xlCellTypeVisible" method., before you write the response to the cell.

Report

Blocked Profile
Nov 2, 2018 at 04:05 PM

Thanks for the feedback!

Paste value on filtered cells [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!