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

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