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
pragati asked 2 weeks 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
naveen answered 2 weeks ago
Your Answer

8 + 16 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com