Excel - macro/code to delete and change line style of drawing objects
Posted on 2003-02-21
I was hoping someone could tell me how I can automatically delete some drawing objects (lines) and then change the line style of others.
Here is the scenerio.....I have approximately 100 spreadsheets, each has 12 columns. These spreadsheets are generated from Oracle ADI...they are financial statements. The "double line" that is in the spreadsheet is not printing very well as it is too squished together. I have tried several different printers to try to remedy this but the results are the same. I have - found that all the lines in these sheets are single line drawing objects, some just close together to make it look like a double line.
I would like a little routine that would do the following:
- Delete lines 74, 76, 78, 80, 82, 84, 86, 88, 90, 92, 94, 96
- Then change the format of the following lines from 3/4 point single to 3 point double 73, 75, 77, 79, 81, 83, 85, 87, 89, 91, 93, 95
Hopefully someone can help me with this. Anything would be really appreciated!!!
Thanks in advance,