ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select all from filter (https://www.excelbanter.com/excel-programming/360425-select-all-filter.html)

alvin Kuiper

Select all from filter
 
Hi

If i use a' filter , like i have 120 post but when i use the filter i have
maybe 8 post
what i want is a macro /button where when i click on this only the visible
post get selected , hope some one understand my queston.

regards
Alvin


Bob Phillips[_14_]

Select all from filter
 
F5Special click 'Visible Cells Only'

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hi

If i use a' filter , like i have 120 post but when i use the filter i have
maybe 8 post
what i want is a macro /button where when i click on this only the visible
post get selected , hope some one understand my queston.

regards
Alvin




alvin Kuiper

Select all from filter
 
Hej bob and thanks
But i want to take this cells
and then say + maybe 10
so if the cells value after filter are 15
then the cells value shall be 25

Hope you understand
regards
alvin


"Bob Phillips" skrev:

F5Special click 'Visible Cells Only'

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hi

If i use a' filter , like i have 120 post but when i use the filter i have
maybe 8 post
what i want is a macro /button where when i click on this only the visible
post get selected , hope some one understand my queston.

regards
Alvin





Bob Phillips[_14_]

Select all from filter
 
Not really, 15 what, 25 what? Rows, value in the cells?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hej bob and thanks
But i want to take this cells
and then say + maybe 10
so if the cells value after filter are 15
then the cells value shall be 25

Hope you understand
regards
alvin


"Bob Phillips" skrev:

F5Special click 'Visible Cells Only'

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"alvin Kuiper" wrote in message
...
Hi

If i use a' filter , like i have 120 post but when i use the filter i

have
maybe 8 post
what i want is a macro /button where when i click on this only the

visible
post get selected , hope some one understand my queston.

regards
Alvin








All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com