#excel macro paste

Excel does not allow pasting to visible cells only when filter. Use below macro to paste into visible cells. First, data to copy need to be in the same sheet. Select the cells to copy then run the macro. It will ask for a paste range, specify the cell range to paste into.

Sub Copy_Filtered_Cells() Set from = Selection Set too = Application.InputBox(“Select range to copy selected cells to”, Type:=8) For Each Cell In from Cell.Copy For Each thing In too If thing.EntireRow.RowHeight > 0 Then thing.PasteSpecial Set too = thing.Offset(1).Resize(too.Rows.Count) Exit For End If Next Next End Sub