Hi all,
So I made a tool that generates Motor Control Center (MCC) layouts from a motor list. In case you don't know what that is, it is essentially a tall narrow metal box with more variable size boxes (all the same width) inside of it. inside the smaller boxes (buckets) are electronics that control motors. Since the boxes can be variable heights I did use merged cells to represent them and found that works very nicely. In the image below you can see 1 MCC with 5 tall narrow metal boxes (sections) mentioned above stacked side by side sharing a single power feed.
AutogenMCC.jpg
Anyways on to my question, my VBA code generates the boxes the correct size and fills in the correct data from the motorlist, but now I want to add an alternate function to take a manually drawn MCC in the same spreadsheet (and following the same format) and fill in an empty motor list on another tab. I have learned that I can use the split function with a chr(10) delimiter to break the multi-line text in each bucket into variables to later be output to the imported motor list, but i'm having trouble with the merged cells especially since they can be anywhere from 1 to 12 cells. Does anyone have any recommendations on a good way to go about this? i refuse to show up without at least some code, so here is my test code that I'm currently work on.
PS I've only been working with VBA for a few weeks now so please forgive any shortcomings.Please Login or Register to view this content.
Thank you
Bookmarks