Sub 跟着加粗() Dim r As Long r = Range("d65536").End(xlUp).Row For i = 1 To r Step 1 If Cells(i, 3).Font.Bold = True Then Cells(i, 4).Font.Bold = True End If Next i End Sub
Sub 跟着加粗() Dim r As Long r = Range("a65536").End(xlUp).Row For i = 1 To r Step 1 If Cells(i, 1).Font.Bold = True Then Rows(i).Font.Bold = True Cells(i, 3).Cut Cells(i, 4) End If Next i End Sub