Menu
Ask a question Report

Paste value on filtered cells [Solved]

Posts
12
Registration date
Monday April 5, 2010
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 

Your reply

Reply to this topic

1 reply

Best answer
Report Respond to ac3mark
Posts
11176
Registration date
Monday June 3, 2013
Status
Contributor
Last seen
January 18, 2019
 1891
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

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 4484 users have said thank you to us this month

Report Respond to ac3mark
ac3mark
Posts
11176
Registration date
Monday June 3, 2013
Status
Contributor
Last seen
January 18, 2019
 1891 -
Thanks for the feedback!
Respond to ac3mark

Your reply

Reply to this topic
Ask a question