View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam[_9_] Adam[_9_] is offline
external usenet poster
 
Posts: 15
Default Excel Macro Basic Help

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