Paste value on filtered cells [Solved]
ehlblackstar
Moderator Last seen
November 17, 2018
- Nov 2, 2018 at 04:05 PM
- Posts
- 12
- Registration date
- Monday April 5, 2010
- Last seen
- November 2, 2018
- Posts
- 10861
- Registration date
- Monday June 3, 2013
- Status
Related:
- Paste value on filtered cells
- Copy paste Rename based on cell value ✓ - Forum - Excel
- Auto copy/paste data if criteria (same value in 2 cells) is met ✓ - Forum - Excel
- Copy filtered data and paste values ✓ - Forum - Office Software
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- Excel change font color based on value of another cell ✓ - Forum - Excel
2 replies
Best answer
- Posts
- 10861
- Registration date
- Monday June 3, 2013
- Status
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.
has helped 1673 users this month
Report
Respond to ac3mark
- Posts
- 10861
- Registration date
- Monday June 3, 2013
- Status
Thanks for the feedback!