can i get Explation of this code

[bhandari]

Set rng = ("A1:A10")
For i = rng.Row + Rows.Count - 1 To rng.Row Step -1

is it mean 11-1 to 10-1?

 

[Scott T]

This is not valid code

Set rng = ("A1:A10")

it should be

Set rng = Range("A1:A10")

This would loop through the entire worksheet starting from the last row and working to row 1

For i = rng.Row + Rows.Count - 1 To rng.Row Step -1

rng.Row is 1

Rows.Count=all the rows in the sheet (dependent on your version of Excell)

Since 1 is added then subtracted you are left with all the rows.

the step -1 tells the code to go back on rather add 1

 

[bhandari]

Thank you very informative