This does the same thing as the code I provided. What I need is each column of two rows separately being merged, not the entire selection. When I use the RefEdit feature it is to get the correct 2 rows, once I have the correct rows I need to merge the same rows but separately in each column...
Tried it, doesn't work. Each column has a border around each cell. "Center across selection" only works with the values inside the cells. I want the border to go around the outside of both cells in a column and center the value inside the entire cell. It's not that much trouble, just need to...
In VBA I can merge two cells in one column after selecting both cells with the Refedit. But if I try to move to the next column and try to merge the same two rows under the same sub procedure, nothing happens. I've tried just about everthing I can think of including offset. Ultimately what I...