Thread
:
A hard DO loop for me
View Single Post
#
5
Posted to microsoft.public.excel.programming
Alan Beban[_2_]
external usenet poster
Posts: 783
A hard DO loop for me
wrote:
Fellow coders,
I have large files of data where I need to
copy every other row alongside the initial
row, and then delete the rows that are
copied.
. . .
If the functions in the freely downloadable file at
http://home.pacbell.net/beban
are available to your workbook:
Range("L2").Resize(Range("B2:K7").Rows.Count \ 2, 10).Value
= _ ArrayAlternates(Range("B2:K7"), False)
Alan Beban
Reply With Quote
Alan Beban[_2_]
View Public Profile
Find all posts by Alan Beban[_2_]