Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have never written Excel macros or written in Visual
Basic before. I am trying to write a macro that will organize my spreadsheet into a certain order. In order to do that, I need to be able to search for a row that has a 0 in the first column cut that row to the beginning of my file. Here is what I have, but it isn't working. For n = 2 To FinalRow If (Range("A" & n).Value) = 0 Then Rows("n:n").Select Selection.Cut Rows("2:2").Select Selection.Insert Shift:=xlDown End If Next n Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set up basic Macro in EXcel to use in other applications | Excel Discussion (Misc queries) | |||
Visual Basic/ Macro date formatting in Excel 97 | Excel Programming | |||
Visual Basic macro to do something that is done trhough an Excel function | Excel Programming | |||
visual basic macro in excel | Excel Programming | |||
visual basic macro in excel | Excel Programming |