I am using CF to add borders to cells to create a 'table'
In column I I need to show notes for the customer but as these can be lenghty, I need to merge the cells in column I to display the note as below
My problem is that the CF set to show borders where required, are broken when I unmerge the merged cells
Below is the defined range prior to the merge
When the unmerge occurs, the range is amended to
As the merge and unmerge is part of a loop to define multiple individual lists of either 1 or many customers, I need to redefine the range after each list has been defined and the relevant cells merged.
As recording the fixing of the defined CF range doesn't record the required code, is there a way of defining the range via VBA?
TIA
In column I I need to show notes for the customer but as these can be lenghty, I need to merge the cells in column I to display the note as below
My problem is that the CF set to show borders where required, are broken when I unmerge the merged cells
Below is the defined range prior to the merge
When the unmerge occurs, the range is amended to
As the merge and unmerge is part of a loop to define multiple individual lists of either 1 or many customers, I need to redefine the range after each list has been defined and the relevant cells merged.
As recording the fixing of the defined CF range doesn't record the required code, is there a way of defining the range via VBA?
TIA
