Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first visible row
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 no hidden. Then I need that row number stored in a variable. I know thi can't be that hard... I'm just retarded! :( Any help would be greatly appreciated! -- m3s3l ----------------------------------------------------------------------- m3s3lf's Profile: http://www.excelforum.com/member.php...fo&userid=3487 View this thread: http://www.excelforum.com/showthread.php?threadid=56870 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first visible row
This will find the first visible row past A4. It doesnt continue on past that for other visible rows. Sub FindFirstHiddenRow() Dim cell As Range Dim rowNum As Integer Set cell = ActiveSheet.Range("A4") While cell.Rows.Hidden = True Set cell = cell.Offset(1, 0) Wend rowNum = cell.Row End Sub -- jtp ------------------------------------------------------------------------ jtp's Profile: http://www.excelforum.com/member.php...o&userid=21132 View this thread: http://www.excelforum.com/showthread...hreadid=568709 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first visible row
If row 4 is not hidden this will give 4 so use 5:100 if you want the NEXT
visible fvr = Rows("4:1000").SpecialCells(xlCellTypeVisible).Row MsgBox fvr -- Don Guillett SalesAid Software "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first visible row
Thank you guys so much! I ended up using the last suggestion, but I appreciate everybody's response! -- m3s3lf ------------------------------------------------------------------------ m3s3lf's Profile: http://www.excelforum.com/member.php...o&userid=34874 View this thread: http://www.excelforum.com/showthread...hreadid=568709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find the number for visible row | Excel Discussion (Misc queries) | |||
find the number for visible row | Excel Discussion (Misc queries) | |||
The 'Move Toolbar' symbol not visible in Excel. How do I find it? | New Users to Excel | |||
How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |