Ok, I have a macro that appends names into cells on a grid, then it autofits then, problem is that once the row height getss over 390, it crashes. So, what i want to do is make every column in the grid actually contain TWO columns. Then, with a little formatting and bordering, it will look like it is only one column. I need help filling in this gap in the code. By the way, an autofit is run every time it loops, so the rowheight would be updated every time.

VB Code:
  1. 'Determine which cell in the grid the employee belongs to
  2.                         With rngGrid.Cells(1 + lResCounter, 1 + lCapCounter)
  3.                        
  4.                         'If the row height is greater than 350, then move to the next column over(but stay in the same row)
  5.                             ' This is where I need help, I don;t know what to put here
  6.                            
  7.                             'Otherwise, just run the normal append code on that cell
  8.                             Else
  9.                        
  10.                             'If this is the first employee being added
  11.                             'don't insert a comma before the name...
  12.                             If .Value = "" Then
  13.                                 .Value = saEmployee(1, lRecordNum)
  14.                             Else
  15.                                 '... otherwise append the employee to the
  16.                                 'list
  17.                                 .Value = .Value & Chr(10) & saEmployee(1, lRecordNum)
  18.                                                          
  19.                             End If
  20.                             End With