| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Merged Cells (Part 2) - Free 58k macro
From the author: 'To use the Merged Cell Finder macro, open the
attached file and leave it open while you go to the sheet on which you want to find all of the merged cells. Then run the "FindMergedCells" macro by doing a Alt+F8 and selecting the macro and clicking "Run" or from the toolbar do a TOOLS MACRO MACROS and select the macro and "Run" as before. The macro will add a new sheet to your workbook with the List of Merged cells. It will not overwrite an existing sheet, so if you want to run it a second time for the same sheet, it will bomb unless you first delete the previously created sheet or rename it.' From me: This saved HOURS of goofing around, editing others' spreadsheets. So good, I offered to pay for it. http://www.ozgrid.com/forum/showthread.php?t=22501 Free 58k macro |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Hybrid Mode
