Paste value on filtered cells [Solved/Closed]

Report
Posts
12
Registration date
Monday April 5, 2010
Status
Member
Last seen
November 2, 2018
-
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
-
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



1 reply

Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,678
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.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4178 users have said thank you to us this month

ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,678
Thanks for the feedback!