hi PaxtonRoadEnd
There are three examples on my site
Read the information
1) Loop through all the rows in the UsedRange (this is the first row with data till the last row with data on your sheet)
It can be slower if the column that you check doesnt use so many rows or if your UsedRange is bigger then you data.
you can find more information on Debra Dalgleish's Web Site about this
http://www.contextures.on.ca/xlfaqApp.html#Unused
2) You can fill in the StartRow and the EndRow yourself.
3) You can fill in the StartRow and the code will find the last row with data in the column that you want to check.
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"PaxtonRoadEnd" wrote in message ...
Ron/lbrrenga
Your loop suggests a limited number of rows under variable EndRow = 100.
If you swap it for
EndRow = Range("a11").UsedRange.Rows.Count
would this make it more dynamic?
Regards
--
BerbatovIsGod
"lbrrenga" wrote:
Hi All,
I need your help to delete (at one single step) all empty rows in the
spread sheet. Can you please help me?
Thanks
Regards
Renga