Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I must find "Not Found" in column P then: n_row = 1 Do While Cells(n_row, 16) = "NOT FOUND" Cells(n_row,20).Value = Cells(n_row,5).Value HEre i need a code like down n_row = nrow + 1 Loop ----Ok but i also must cut and like this down Sub Macro4() ActiveWindow.SmallScroll ToRight:=-2 Range("E73").Select Selection.Copy ActiveWindow.Zoom = 75 Range("Q73").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Selection.Copy Range("E73").Select ActiveSheet.Paste Range("E76").Select Application.CutCopyMode = False Selection.Copy Range("Q76").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Selection.ClearContents Range("E76").Select Selection.Copy Range("Q76").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Selection.Copy Range("E76").Select ActiveSheet.Paste End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AUTOMATIC COLUMN TRACKING | Excel Worksheet Functions | |||
Automatic sum of a column when the other column has the same vaule | Excel Discussion (Misc queries) | |||
Automatic filtering and coping result to a seperate sheet | Excel Worksheet Functions | |||
Automatic Text to column | Excel Discussion (Misc queries) | |||
coping | New Users to Excel |