Maybe somebody can help me out this one has boggled me for a couple days (weeks actually) so any help is appreciated. See attached file for layout. I am trying to create a macro three actually all deviations from one. Here is my problem I am currently to create a macro that is attached to a shape. That part is really not the problem. It is the macro I can get half or it to work or sometimes all of it to work and I am just a little fu$#%^& frustrated so I am hoping someone can help. I want to be able to select the shape and the cells that are selected to merge, or un-merge back to the way it currently is (two cells already merged) when selected I wanted to have three macros one for the column labeled “B”, one for the “N/A” column and one for the “Description” column the only difference between the three would be the way the text is aligned for the “b” and “N/A” column the text would be center, center and for the description to be left, center, or right center depending on the column selected “E” would be left, center and column “I” right centered. Thanks in advance for the help it is greatly appreciated, I will continue to work on this also hopefully I can learn form someone else’s expertise. Thanks. for some reason I cannot get the file attached..any suggesstions?