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

A range includes all cells in it, including hidden rows. If you want just
visible rows:

Range("sheet1!_filterdatabase").SpecialCells(xlCellTypeVisible)

--
Jim
"Dan" <(E-Mail Removed)> wrote in message
news:3EEAD577-293D-4EE7-9393-(E-Mail Removed)...
| 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

Great

"Jim Rech" wrote:

> A range includes all cells in it, including hidden rows. If you want just
> visible rows:
>
> Range("sheet1!_filterdatabase").SpecialCells(xlCellTypeVisible)
>
> --
> Jim
> "Dan" <(E-Mail Removed)> wrote in message
> news:3EEAD577-293D-4EE7-9393-(E-Mail Removed)...
> | 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
>
>
>