Paste array into filtered range

Hi all,

I'm using below code to concatenate 3 columns on a sheet and then paste the concatenated array back in column A. This works great if all columns are unfiltered, however, if they are not, it does take all values from the sheet (which it should) but when pasting it back in column A, it seems to only paste it in the visible cells rather than every cell. How can I paste it to all cells including the "hidden" ones without unfiltering first?

Please Login or Register  to view this content.