Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know my programming level is low and sure the mistake is a begginers
mistake...I want to insert a row if the number in row i+1 is bigger than number than number in row i. The code I've written is this: Private Sub CommandButton1_Click() Dim i As Integer For i = 1 To 10 If Worksheets("sheet1").Range("B" & i).Value < Worksheets("sheet1").Range("B" & i + 1).Value Then Rows("i:i").Insert Shift:=xlDown End If Next End Sub I can't find the mistake, can you help me???? Thanks! -- atrep |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Newbee made a big mistake | Excel Discussion (Misc queries) | |||
Circular reference mistake | Excel Worksheet Functions | |||
mistake in formula | Excel Discussion (Misc queries) | |||
I saved it by mistake!!!! | Excel Worksheet Functions | |||
If I get the help box up by hitting F1 by mistake, how can I get . | Excel Discussion (Misc queries) |