Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a strong need to select any row and the immediate row. I know
definite rows can be selected as - Rows("20:21").Select . Whenever I try a variableble like Rows("Z:Z+1") or Rows(Z:Z+1) it usually doesnt work. The attempt is shown below: Range("K" & Z).Select If Range("K" & Z).Value < 1 And Abs(Range("K" & Z).Value) = Abs(Range("K" & Z + 1).Value) Rows("Z:Z+1").Select Selection.Cut Sheets("bin").Select Range("A" & X).Select ActiveSheet.Paste Pls help on the right syntax |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting rows - syntax wrong? | Excel Discussion (Misc queries) | |||
Syntax for using variables in a cell formula to reference paths/fi | Excel Worksheet Functions | |||
Range.Select Using Variables - need syntax | Excel Discussion (Misc queries) | |||
Syntax for Countnig Rows | Excel Programming | |||
Using variables with ROWs | Excel Programming |