| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows for visible cells
Hi,
I need to capture only those rows which are visible in xls (but not hidden) in my macro. Could some one plz help me in this regard. I I understand how to select only the visible cells (shown below) but how can i capture the rows or row number only for the visible cells. for eg: Range("A1:A6").Select Selection.SpecialCells(xlCellTypeVisible).Select Thanks digger |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select only used rows and only visible cells | Excel Discussion (Misc queries) | |||
| Function to display a count of visible cells/rows... doesn't | Excel Programming | |||
| Keep certain cells visible when scrolling, not just rows or colum | Excel Worksheet Functions | |||
| xlVisibleCellsOnly Help to copy only Visible Cells/Rows | Excel Programming | |||
| Help: Copying Visible Cells only to Visible cells! | Excel Programming | |||
Threaded Mode
