Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
_filterdatabase
A range includes all cells in it, including hidden rows. If you want just
visible rows: Range("sheet1!_filterdatabase").SpecialCells(xlCel lTypeVisible) -- Jim "Dan" wrote in message ... | Hi there, | Where does excel save the result of of a filterd selection, I thought it was | (for example on sheet 1) on sheet1!_filterdatabase | | but when running: | Sub test1() | For Each cell In Range("sheet1!_filterdatabase") | Debug.Print cell.Value | Next cell | End Sub | | I noticed it include all the table and not only the result. | | Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
_filterdatabase
Great
"Jim Rech" wrote: A range includes all cells in it, including hidden rows. If you want just visible rows: Range("sheet1!_filterdatabase").SpecialCells(xlCel lTypeVisible) -- Jim "Dan" wrote in message ... | Hi there, | Where does excel save the result of of a filterd selection, I thought it was | (for example on sheet 1) on sheet1!_filterdatabase | | but when running: | Sub test1() | For Each cell In Range("sheet1!_filterdatabase") | Debug.Print cell.Value | Next cell | End Sub | | I noticed it include all the table and not only the result. | | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter _FilterDatabase Rowsource Listbox | Excel Programming |