Help, For loop to run on each row to bottom of workbook

[ViperD]

I'm trying to run a for loop from 1 to x, where x is the last row in the workbook. How would I go about retreiving the number of the last row with data?


Thanks

 

[SkipVought]

Hi,

One way...

  With Activesheet.UsedRange
    x = .Row + .Rows.Count - 1
  End With

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[Zathras]

If you look in the VBA forum (forum707) you can find a couple of FAQ's that address that issue.