I might suggest a different approach than opening the CSVs in Excel.
You could use standard VBA file I/O to read the data into an array,
iterate the array for the data to keep and put that into an output
array. When the 'DataToKeep' has been collected then 'dump' it into a
worksheet.

I suggest using just 1 color to shade your columns so that every odd
(or even) set is shaded and the sets between are not. So cols A/B would
be light green, say, cols C/D would be normal, cols E/F would be light
green, cols G/H would be normal, ..and so on.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion