View Single Post
 
Old 04-01-2024, 11:44 AM
TessaMurillo TessaMurillo is offline Windows Vista Office 2010
Advanced Beginner
 
Join Date: Mar 2024
Posts: 32
TessaMurillo has a little shameless behaviour in the past
Default

Hello!

You can use a VBA macro in Excel to perform this task. Here's some sample code that might help you:

Set rng = Range("A1:E10") ' Replace "A1:E10" with the range of your table

For Each cell In rng

If cell.Borders(xlEdgeTop).LineStyle <> xlNone And cell.MergeCells = False Then

Continue on my own, because I don’t know
Reply With Quote