View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Find first visible row

maybe something like this

Sub test()
Dim firstrow As Long
firstrow = Worksheets("sheet1").Range("A4").End(xlDown).Row
MsgBox firstrow

End Sub

--


Gary


"m3s3lf" wrote in message
...

Can somebody *please* help me with this code...

I need to start at row 4, and go down until I find a row that is not
hidden. Then I need that row number stored in a variable. I know this
can't be that hard... I'm just retarded! :(

Any help would be greatly appreciated!!


--
m3s3lf
------------------------------------------------------------------------
m3s3lf's Profile:
http://www.excelforum.com/member.php...o&userid=34874
View this thread: http://www.excelforum.com/showthread...hreadid=568709