Question
November 26, 2007 at 04:32 AM
er.kanwaldeep

how can transfer data from one exce worksheet to another sheet

by er.kanwaldeep . Updated 18 years, 11 months ago

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.

This discussion is locked

All Comments