Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting and pasting to an empty cell
Dear Great Minds of Excel,
I'm trying to write a macro for exel to copy a row in one workshee then paste it in another worksheet but in an empty cell right below th previous paste. For example: Worksheet 1 1 2 3 4 <---Copy worksheet 2 0 0 0 1 1 2 3 4 <--- Then paste below 0 0 0 1 I think I would use active offset but it is not working. Can anyon help? Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting and pasting to an empty cell
One way:
Activecell.EntireRow.Copy Destination:=Sheets("Sheet2").Range( _ "A" & Rows.Count).End(xlUp).Offset(1, 0) In article , Craig from MI wrote: Dear Great Minds of Excel, I'm trying to write a macro for exel to copy a row in one worksheet then paste it in another worksheet but in an empty cell right below the previous paste. For example: Worksheet 1 1 2 3 4 <---Copy worksheet 2 0 0 0 1 1 2 3 4 <--- Then paste below 0 0 0 1 I think I would use active offset but it is not working. Can anyone help? Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
Selecting occupied cell over empty ones | Excel Discussion (Misc queries) | |||
selecting next empty cell | Excel Discussion (Misc queries) | |||
Pasting data top 1st empty cell in range | Excel Discussion (Misc queries) |