CorBlimeyLimey,
Thanks for your input. I have seem to of found a workaround on the formatting problem. I was adding cells with our company info above where you would put a header.
As far as the merge problem it was a simple solution. I was using a SW BOM template and they have the: "Share...
Hello...I'm Johnny Cash,
I am trying to create a Excel based BOM that I can save separatley from the DWG, so that other departments in my company have access to it.
Although the problems that I am having are many, I shall not burden you with them all.The one that is causing me the most...