Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving up one cell
Dear all,
I have the following simple code:- Range("E20").Select Selection.Copy Cells.Find(What:="TECHNOLOGIES", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Selection.End(xlDown).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Once I have found what I am looking for I would like to move up 1 (one) cell and then paste the data. Can you help? -- Thank you in advance for your Help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving up one cell
Selection.Offset(-1,0).Select
-- Gary''s Student - gsnu200747 "Hans Dummer" wrote: Dear all, I have the following simple code:- Range("E20").Select Selection.Copy Cells.Find(What:="TECHNOLOGIES", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Selection.End(xlDown).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Once I have found what I am looking for I would like to move up 1 (one) cell and then paste the data. Can you help? -- Thank you in advance for your Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving up one cell
Thank you
"Gary''s Student" wrote: Selection.Offset(-1,0).Select -- Gary''s Student - gsnu200747 "Hans Dummer" wrote: Dear all, I have the following simple code:- Range("E20").Select Selection.Copy Cells.Find(What:="TECHNOLOGIES", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Selection.End(xlDown).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Once I have found what I am looking for I would like to move up 1 (one) cell and then paste the data. Can you help? -- Thank you in advance for your Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow keys moving whole excel sprdsht insted of from cell to cell | New Users to Excel | |||
Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
Moving cell contents to new cell loses background color in old cel | Excel Discussion (Misc queries) | |||
Arrows not moving from cell to cell, when I push arrow columns m | Excel Discussion (Misc queries) | |||
Force user to enter data in cell before moving to next cell | New Users to Excel |