Hi,

Whenever filter is active and we try to copy some data, excel copy only visible cells & pasted them adjacently without leaving any cell blank.

In your case, when filter is active and columns F-G and V-AA are hidden, excel is copying only A3:E3 (5 cells), H3:U3 (14 cells) and AB3:IV3 (229 cells) in row 3 and pasting them at A4:IN4 (248 cells) without leaving any blank cell.

My suggestion for you is to do this step when filter is not active. Then all 256 cells in a row will be copied and pasted. This will help you.

If problem persist, please let me know.