Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying rows selected by filter
Scenario:
Our course details are held in a single spreadsheet with a column identifying the Curriculum Area. For each Curriculum Area we need to publish data from this spreadsheet on our intranet. Requirement: Filter this spreadsheet by Curriculum Area and code a macro to write the HTML <table code for all selected rows to a text file. Problem: How do I identify programatically the rows selected by the filter so that I can read through these rows only and write <tr <td lines for each one? Thanks for time, Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying rows selected by filter
Fred,
You want to use special cells method- Dim rng as Range For each rng in Range(Curriculum Area).SpecialCells(xlCellTypeVisible) do something with rng Next rng -- Chris Farkas Excel/Access Developer http://www.eAlchemy.biz "Fred Davis" wrote: Scenario: Our course details are held in a single spreadsheet with a column identifying the Curriculum Area. For each Curriculum Area we need to publish data from this spreadsheet on our intranet. Requirement: Filter this spreadsheet by Curriculum Area and code a macro to write the HTML <table code for all selected rows to a text file. Problem: How do I identify programatically the rows selected by the filter so that I can read through these rows only and write <tr <td lines for each one? Thanks for time, Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Filter on Selected rows and columns | Excel Discussion (Misc queries) | |||
Using Advanced Filter: How do you MOVE the selected rows... | Excel Worksheet Functions | |||
No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
Identifying the Selected Cell | Excel Programming | |||
Identifying the selected Shape | Excel Programming |