View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
singlgl1[_2_] singlgl1[_2_] is offline
external usenet poster
 
Posts: 1
Default Find second blank row


Can someone edit this so that it will find the second blank row instead
of the first blank row? Thanks


Function FindBlankRow()
x = 2
Do While ActiveSheet.Cells(x, 1) < ""
x = x + 1
Loop
FindBlankRow = x - 1


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile: http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=488377