Gustav Brock
gustav at cactus.dk
Mon Feb 10 10:42:18 CST 2003
Hi Mark > Does anyone have sample code that will format the data in Excel (thru a > macro, I guess)? > I've never used a macro in Excel, but this sounds promising. The easy route - as a start - is to record a macro and then study what it has carried out. Then adjust and refine as needed. The final part will be to exchange all the clumsy and slow "selecting" code with code that defines ranges you then manipulate. There is a learning curve, but it can be quite fun as you can do so many things in Excel. /gustav