| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to test for a Row being Visible on a Spreadsheet
Set ran1 = Intersect(Rows(6), Cells.SpecialCells(xlCellTypeVisible))
Thanks to all for your replies. Rick's intersect statement above works fine. Keep up the good work. Niall H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make more columns visible in a spreadsheet? | Excel Discussion (Misc queries) | |||
| spreadsheet not visible | Excel Discussion (Misc queries) | |||
| excel spreadsheet not visible | Excel Discussion (Misc queries) | |||
| Word art and drawings not visible in spreadsheet | Excel Discussion (Misc queries) | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Hybrid Mode
