Question Locked
how can transfer data from one exce worksheet to another sheet
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i have written the code but it doesn't work.
-----------code----------------
ActiveWorkbook.Sheets(1).Activate
ActiveWorkbook.Sheets(1).Range(Cells(1, 1), Cells(1, 2)).Select
Selection.Copy
ActiveWorkbook.Sheets(3).Activate
ActiveWorkbook.Sheets(3).Range(Cells(1, 1), Cells(1, 2)).Select
ActiveWorkbook.Sheets(1).Paste
Application.CutCopyMode = False
----------code-------------------
let me know where some code is missed.