Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Paste value on filtered cells [Solved/Closed]

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

Answer 1 / 1

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
1
Thank you

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

CCM 2905 users have said thank you to us this month

Report
Blocked Profile
Thanks for the feedback!
Ask a question