Macro to copy a row and paste
Closed
Dustin0479
-
Sep 3, 2009 at 01:16 PM
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 - Sep 3, 2009 at 01:51 PM
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 - Sep 3, 2009 at 01:51 PM
Related:
- Macro to copy a row and paste
- Saints row 2 cheats - Guide
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
- How to delete row in word - Guide
1 response
sadgurl
Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
219
Sep 3, 2009 at 01:51 PM
Sep 3, 2009 at 01:51 PM
Hello here is a little script:
Sub test()
Sheet2.Rows(1).Copy
Sheet1.Activate
Rows(1).Select
ActiveSheet.Paste
End Sub
it will copy row 1 on sheet 2 an past it in rows1 on sheet 1
if you need to found out the next free row, just loop until rows(x).value = null where x it the index of the row to be checked
Sub test()
Sheet2.Rows(1).Copy
Sheet1.Activate
Rows(1).Select
ActiveSheet.Paste
End Sub
it will copy row 1 on sheet 2 an past it in rows1 on sheet 1
if you need to found out the next free row, just loop until rows(x).value = null where x it the index of the row to be checked
