Microsoft Office Forums - View Single Post - [Solved] using a macro and then go to another row

Thread: [Solved] using a macro and then go to another row

View Single Post

Old

08-12-2014, 10:26 PM

RAJUSINGH.1111 RAJUSINGH.1111 is offline

RAJUSINGH.1111 is offline

RAJUSINGH.1111 uses Windows 7 64bit

Windows 7 64bit RAJUSINGH.1111 uses Office 2007

RAJUSINGH.1111 uses Office 2007

Office 2007

Novice

Join Date: Aug 2014

Location: New Delhi

Posts: 3

RAJUSINGH.1111 is on a distinguished road

Default

You need to use offset to go another cells down
Sheets("Sheet1).Select
Selection.Offset(Rows,Columns).Select
Selection.Copy
Sheets("Sheet2").Select
Selection.Offset(Rows,Columns).Select
ActiveSheet.Paste
Application.CutCopyMode=False

------------
Raju Singh

Reply With Quote