Try to search your question here, if you can't find : Ask Any Question Now ?

Copy and paste and keep hidden after pasting

HomeCategory: stackoverflowCopy and paste and keep hidden after pasting
Avatarpragati asked 5 months ago

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.

Sub selectVisibleRange()

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
1 Answers
Best Answer
Avatarnaveen answered 5 months ago
Your Answer

0 + 7 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com