ok I will look into that


>>after looking at the macro tool for excel I ran a test about 50% of the code worked fine the other 50% just took a little gray matter. The "xTopBorder" had to be replaced with numbers, after a few test I found the number(s) I was looking for.
>
>You do not need to guess the magic numbers. Use an include file. You can find Excel.H in many places, including Excel's VBA object browser or also at the Wiki:
>http://fox.wikis.com/wc.dll?Wiki~ExcelConstants~VFP
>
>Put that in a file called Excel.h and somewhere in your program add:
>
>#INCLUDE Excel.h
>
>Then you can just use the constant's names like xTopBorder in your statements.