Menu
Ask a question Report

Paste value on filtered cells [Solved]

Posts
12
Registration date
Monday April 5, 2010
Status
Member
Last seen
November 2, 2018
 -
Excel Ask a question Report
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 

1 reply

Best answer
Report Respond to ac3mark
Posts
13035
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1476
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.

Say "Thank you" 1

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

CCM 6300 users have said thank you to us this month

Report Respond to ac3mark
ac3mark
Posts
13035
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1476 -
Thanks for the feedback!
Respond to ac3mark
Reply Ask a question