here's a link someone posted earlier today

http://www.mvps.org/dmcritchie/excel...emoveEmptyRows

--


Gary


"J Streger" wrote in message
...
I currently am writing a procedure to automatically delete rows that are
blank (and add new ones when needed. I'm trying to avoid using
worksheetfunction(counta) to determine if an entire row is blank as well
as
looping through each cell in the row to see if there is data there. Is
there
a way programatically to determine if any data exists in the given row?
Thank
you.


--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003