Forum Discussion
VBA - trying to automate formatting of data - merge cells of varying number of rows
Hello gms4b , merged cells cause a lot of problems and should be avoided wherever possible. Maybe it's possible to find a different approach. Why to you want the text in column A and the values in E and F centered horizontally? Is it aesthetics or does it have a functional reason?
Yes, it's for aesthetics. The merged and centered cells become the final readout for a report and look good presentation-wise. Column A is the topic of the chart. Columns B and C readout data individual pieces of data. Columns E and F are averages and standard deviations of the 6 pieces of data. There are lines of code and sheets of data that get to this final readout. And its not just 1 this one case...i'll have to make this code work for, like, 20 of these tables...so I'd like to automate it.
