Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

print selected rows to a file

Posted by Cindy Kelly on August 16, 1999 12:14 PM

Can anyone tell me how to write a macro that would print
every 5th row of data to a file?

Thanks

Re: print selected rows to a file

Posted by Ivan Moala on August 17, 1999 4:13 AM

Cindy
Have a look @ the online help re:Print # Statement
What you would have to do is loop over your data
range to select every 5th row and stor the results
in a dynamic array (assuming you don't know the size of the data array to save)
have a look @http://w1.2735.telia.com/~u273500023/english/index.htm for tips

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.