using a macro and then go to another row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
using a macro and then go to another row

FAQ

Thread Tools

Display Modes

08-12-2014, 10:26 PM

RAJUSINGH.1111 RAJUSINGH.1111 is offline

Windows 7 64bit using a macro and then go to another row

Office 2007

Novice

Join Date: Aug 2014

Location: New Delhi

Posts: 3

RAJUSINGH.1111 is on a distinguished road

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

Tags

macro, navigation

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Needed to bold specific lines and Macro to turn into CSV	anewteacher	Word VBA	1	05-28-2014 03:59 PM
custom icon, undo/redo for macro, permanent macro	Rapier	Excel	0	08-05-2013 06:30 AM
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:36 PM.