kayalvizhi kandhan
New Member
- Joined
- Aug 11, 2020
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
hi
i am using this code to copy one column data from worksheets(sample_sheet) and paste the into another hidden excel workbook i.e., Worksheets("Transaction level details").. i use this code , but "paste " is not working, kindly help me
''Selection the Description Begings with "Deposit" criteria
With Worksheets(sample_sheet)
.Range("C2").Select
.Range(Selection, Selection.End(xlDown)).Select
.Selection.Copy
End With
'Worksheets("Transaction level details").Visible = xlSheetVisible
With Windows("Excel Sheet format.xlsx")
.Activate
.Range("G" & filled_row).Select
.Selection.PasteSpecial xlPasteValues
End With
i am using this code to copy one column data from worksheets(sample_sheet) and paste the into another hidden excel workbook i.e., Worksheets("Transaction level details").. i use this code , but "paste " is not working, kindly help me
''Selection the Description Begings with "Deposit" criteria
With Worksheets(sample_sheet)
.Range("C2").Select
.Range(Selection, Selection.End(xlDown)).Select
.Selection.Copy
End With
'Worksheets("Transaction level details").Visible = xlSheetVisible
With Windows("Excel Sheet format.xlsx")
.Activate
.Range("G" & filled_row).Select
.Selection.PasteSpecial xlPasteValues
End With