Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code not going to next unused row
Hi ng
using xl 2003 My code is not pasting to next unused row Should begin pasting row 9 Every time I run the code pastes further down and down What am I doing wrong? Sub Add_Employee() Worksheets("mytools").Activate Range("A1:J7").Select With Range("A1:J7") .Copy End With Worksheets("Time_Entry").Activate Cells(Cells.SpecialCells(xlCellTypeLastCell).Row, 1).Select ActiveSheet.Paste Application.CutCopyMode = False End Su -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying to next unused row | Excel Worksheet Functions | |||
Finding the last unused row in a column | Excel Worksheet Functions | |||
what to do with unused cells | Excel Worksheet Functions | |||
Eliminate unused columns | Excel Discussion (Misc queries) | |||
find next unused row | Excel Programming |