Please explain this macro for me..please kindly, thank you!

[pedie]

In the code below i want a few clarification...

#1. does i as long means that i col A?

and below that is writen for i = 512 to 1 step -1; does this means it will go till row 512 of col A
and #2. what does to 1 step -1 mean?

#3. with cells(i,1); what is tis supose to do?

Please help...and explain this..thanks alot!
I'm learning all this from you guys thanks alot!

Sub exa1()
Dim i As Long

For i = 512 To 1 Step -1
With Cells(i, 1)
If Len(.Value) Then .Offset(1).Resize(4).EntireRow.Delete
End With
Next
End Sub

 

[VoG]

Does this help?

Sub exa1()
Dim i As Long ' declares i as a long integer (can hold values from -2,147,483,648 to 2,147,483,647)
For i = 512 To 1 Step -1 ' loop backwards freom row 512 to row 1, one row at a time
    With Cells(i, 1) ' cells(i,1) means A1 when i = 1, A2 when i = 2 and so on
        If Len(.Value) Then .Offset(1).Resize(4).EntireRow.Delete
    End With
Next
End Sub

 

[pedie]

Cheers to Vog!!!

And to who so ever created this site and So called amazing helpfull BOARD..


Great Thanks!!!

 

[VoG]

From some of your recent posts I think that you are trying to learn VBA. That is laudable but difficult if you are just trying to understand posted code. Take a look at this http://www.add-ins.com/vbhelp.htm

 

[pedie]

Yes that is correct...i'm learning from everywhere possible.

Vog~! Thanks alot once for all your help....