_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

_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