Question Regarding Splitting cells and Format

Cendrinne · #1 01-20-2025, 07:02 PM

Hi Pros,

I've been searching without finding answers.

When we split a cell in two. Why the format, for ie: Bold on the first cell, well the second cell doesn't keep the format? ****In my case, it's when we share word documents within a team.*****

Cause I have a wonderful macros, that splits the cells, moved the symbol %$ to the next cell, but I must fix every table where one column has a specific format, I must select the next columns manually to keep the format.

Or is there a solution to this task?

If there was a thread on this topic, I do apologize, I just didn't find it.

Cendrinne · #2 01-20-2025, 07:50 PM

Hello Pros and others reading this.

I've created a macro to search IF a cell is Bold.
If it is, then Remove Bold, then Put Back Bold.

HTML Code:

Sub All_Tables_FNR_IF_Bold_Tuggle_Bold_False_Bold_True()
Dim xTbl As Table
Dim aCel As cell
Dim oRng As Range
  
Application.ScreenUpdating = False

For Each xTbl In ActiveDocument.Range.Tables
  For Each aCel In xTbl.Range.Cells
     If aCel.Range.Font.Bold = True Then

'******** Good below
      
      aCel.Range.Font.Bold = False
      aCel.Range.Font.Bold = True
    End If
  Next aCel
Next
  Application.ScreenUpdating = True
  Application.ScreenRefresh
  DoEvents
  
lbl_Exit:
  Set xTbl = Nothing
  Set oRng = Nothing
  Exit Sub
  
  On Error GoTo 0
  
End Sub

Then if we split the cell, it keeps the bold format. Not sure for the rest, but I imagine doing this for the rest of the tables, before the split.

Maybe there is a other solution, but I'm no expert, but I've managed to find a solution to my problem

Guessed · #3 01-21-2025, 08:45 PM

You would need to post a sample document that demonstrates the problem but I would guess that your issue is caused by the Table Style settings.

Tables always have a table style associated with them. And each table has a series of options that turn on/off conditions for that table style. There is an on/off setting for the First Column condition in the table - often this setting would be making the text in the first cell Bold. If I was to split the first cell, this setting could make the new first cell bold whilst the new second cell (which now isn't in the first column) would not be bold.

So look at the table style applied and check which table style conditions are turned on.

Cendrinne · #4 01-22-2025, 09:15 AM

Thanks so much, at least I have a direction to search.

I'll do that in my spare time, usually weekends or evenings, then I will come back with the results

Thanks again, really appreciate it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Splitting Tables containing Merged Cells	bpike	Word VBA	7	10-28-2020 02:23 AM
Splitting paragraphs in cells into several cells	mthwi	Excel Programming	2	01-25-2018 05:27 PM
Splitting Cells in a Very Large Table	Paulvana	Word	4	01-06-2017 01:52 PM
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question	rsrasc	Word VBA	7	03-28-2014 12:28 PM
Preventing cells from splitting into two pages	Jaymond Flurrie	Word VBA	1	05-11-2011 06:54 PM