I am writing a code for automatically reading in data from a closed workbook.
I am having some problems with the formating. The problem is when I am reading in some text in a row (each text is followed by six empty cells), and I am trying to merge the following blank cells.
For Row = 1 To NumRows For Column = 3 To LastColumn Range(Cells(Row, Column).Address, Cells(Row + 1, Column + 6).Address).Merge ...
This merges everything into one cell. If I have 10 cells containing text, I want ten merged cells.