Paste value on filtered cells [Solved]

Posts
12
Registration date
Monday April 5, 2010
Last seen
November 2, 2018
- Nov 1, 2018 at 05:29 AM - Latest reply:
Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- 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



See more 

Your reply

2 replies

Best answer
Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- Nov 1, 2018 at 05:17 PM
1
Thank you
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.

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1673 users this month

Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- Nov 2, 2018 at 04:05 PM
Thanks for the feedback!
Respond to ac3mark