How do I paste a single value to a Filtered Range and INCLUDE hidden cells?

[UniMord]

I'd like to copy a value into a filtered range and include the hidden cells. When you're pasting a series of cells, this is the default, usually undesired, behavior.
But when the value originates from a single cell, or is a control+enter, the hidden cells are ignored. Picture a filtered table, where I want to enter FALSE into all the visible cells and everything in between (i.e., hidden). Is there any easy way to achieve this without having to clear the filter?

 

[UniMord]

As a last resort, if there really is no native way to accomplish this, we can loop through the range, like below (Note: requires reference to Microsoft Forms 2.0 Object Library). Any ideas?

[COLOR=#E56717][B]Sub[/B][/COLOR] PasteIncludingHidden()
[COLOR=#151B8D][B]    On[/B][/COLOR] [COLOR=#151B8D][B]Error[/B][/COLOR] [COLOR=#8D38C9][B]GoTo[/B][/COLOR] Finish [COLOR=#008000]'If clipboard is empty.
    [/COLOR][COLOR=#151B8D][B]Dim[/B][/COLOR] cel [COLOR=#151B8D][B]As[/B][/COLOR] Range
[COLOR=#151B8D][B]    Dim[/B][/COLOR] DataObj [COLOR=#151B8D][B]As[/B][/COLOR] [COLOR=#E56717][B]New[/B][/COLOR] MSForms.DataObject: DataObj.GetFromClipboard
[COLOR=#151B8D][B]    Dim[/B][/COLOR] paste$: paste = DataObj.GetText: paste = Left(paste, Len(paste) - 2)
    Application.ScreenUpdating = [COLOR=#00C2FF][B]False[/B][/COLOR]
[COLOR=#8D38C9][B]    For[/B][/COLOR] [COLOR=#8D38C9][B]Each[/B][/COLOR] cel [COLOR=#8D38C9][B]In[/B][/COLOR] Selection
        cel = paste
[COLOR=#8D38C9][B]    Next[/B][/COLOR] cel
Finish:
    Application.ScreenUpdating = [COLOR=#00C2FF][B]True[/B][/COLOR]
[COLOR=#8D38C9][B]End[/B][/COLOR] [COLOR=#E56717][B]Sub[/B][/COLOR]

 

[UniMord]

I posted this question at a different forum and received a more efficient solution than the loop I'd suggested: http://forum.chandoo.org/threads/can-hidden-destination-rows-be-included-when-pasting.34515/#post-206497"

 

[SpillerBD]

Filtered cells and hidden cells act differently. From the average users perspective there is no difference, but (gotcha') there is.
If you do a normal copy from filtered cells, you will not copy what you do not see.
If you do a normal copy from hidden cells, you will copy what you do not see.

If your target range had hidden cells instead of filtered cells you'd be fine.

 

[UniMord]

Thank you, that is good information. In short, there is no non-VBA way to get at the filtered cells.

 

[UniMord]

Correction: Paste Special, Values Only, or Skip Blanks, will get the job done! Solved! (solution by p45cal at the aforementioned forum).