software

I am trying to take a mail list that is in Excel and create a macro to only
show every 10th row. I need these addresses for a survey, so it doesn't make
any difference wheather there is information in all the columns of the
worksheet or not.

Add a column that contains the number sequence 1 through 10, repeating, down
the sheet as far as there is data. Apply an
AutoFilter(Datagt;Filtergt;AutoFilter) to your column header. In the drop down
in the header of your new column, select any number between 1 and 10.
Visible result: every 10th row.

HTH,
--
George Nicholson

Remove 'Junk' from return address.quot;Lindaquot; gt; wrote in message
...
gt;I am trying to take a mail list that is in Excel and create a macro to only
gt; show every 10th row. I need these addresses for a survey, so it doesn't
gt; make
gt; any difference wheather there is information in all the columns of the
gt; worksheet or not.
Thank you. That was exactly what I was hoping for.

Lindaquot;George Nicholsonquot; wrote:

gt; Add a column that contains the number sequence 1 through 10, repeating, down
gt; the sheet as far as there is data. Apply an
gt; AutoFilter(Datagt;Filtergt;AutoFilter) to your column header. In the drop down
gt; in the header of your new column, select any number between 1 and 10.
gt; Visible result: every 10th row.
gt;
gt; HTH,
gt; --
gt; George Nicholson
gt;
gt; Remove 'Junk' from return address.
gt;
gt;
gt; quot;Lindaquot; gt; wrote in message
gt; ...
gt; gt;I am trying to take a mail list that is in Excel and create a macro to only
gt; gt; show every 10th row. I need these addresses for a survey, so it doesn't
gt; gt; make
gt; gt; any difference wheather there is information in all the columns of the
gt; gt; worksheet or not.
gt;
gt;
gt;