View Single Post
 
Old 06-13-2020, 11:47 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

No in a VBA module.

Best to add to your Personal Macro Workbook if you are going to use it.

This explain how to create the Personal Macro workbook https://www.myonlinetraininghub.com/...-personal-xlsb

Once done, copy that code into a module and create a shortcut button on your quick access toolbar.

Then when yoiu want to merge 2 cells select the top one, click the button and it will be meged (only works on 2 cells vertically - but possible to improve)

Purfleet
Reply With Quote