Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
DomThePom wrote:
Use RowHeight property of range object as follows: ****************code starts************* Sub GoToNextVisibleCellDown() Dim cell As Range Set cell = ActiveCell Do Set cell = cell.Offset(1, 0) Loop While cell.RowHeight = 0 cell.Select Set cell = Nothing End Sub ****************code ends************* ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Excellent, thank you. I'm a bit of a novice as you might have guessed! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Excel sheet: selection of cell or rows not visible. | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) |