Please help me on this code. All i want is to copy a data and paste it to cell and keep it hidden. but after using my code and pasting it, still visible. How can i make a vba code that after pasting, it will hide the cell.. Please help me. Thanks.
Dim DbExtract, DuplicateRecords As Worksheet
Set DbExtract = ThisWorkbook.Sheets(“Sheet2”)
Set DuplicateRecords = ThisWorkbook.Sheets(“Sheet1”)
DbExtract.Range("X:X").SpecialCells(xlCellTypeVisible).Copy DuplicateRecords.Cells(1, 3).PasteSpecial Paste:=8 End Sub