Merge Cells with between top and bottom border

		Microsoft Office Forums > Microsoft Word > Word VBA
Merge Cells with between top and bottom border

FAQ

Thread Tools

Display Modes

04-01-2024, 11:44 AM

TessaMurillo TessaMurillo is offline

Windows Vista Merge Cells with between top and bottom border

Office 2010

Advanced Beginner

Join Date: Mar 2024

Posts: 33

TessaMurillo has a little shameless behaviour in the past

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bottom border	arvin_cool88	Mail Merge	0	02-20-2024 04:45 AM
Bottom border on every page break	Marcia	Excel Programming	0	01-30-2019 06:42 AM
Table bottom border not performing well	herpez	Word Tables	2	01-16-2017 03:43 PM
How to extend a table bottom border to the end of the page	mikemike616	Word VBA	1	08-20-2015 08:08 PM
Bottom border doesn't display at certain zoom	Cosmo	Word Tables	1	10-09-2013 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 PM.