JonRowland
Active Member
- Joined
- May 9, 2003
- Messages
- 417
- Office Version
- 365
- Platform
- Windows
Hi guys,
Before I start the workbook I'm talking about wasn't created by me, I've been ask to help sort it out.
The file is question is large and in random places are merged cells which contain images. (I've set the properties to move & size with the cells). What I ideally would like and presume VBA it the way to go is.
1. Unmerge the Merge Cells
2. Sort the Worksheet by Column A maintain Row Height formatting.
3. Re-Merged those cells that were merged.
Any ideas or tips please???
Before I start the workbook I'm talking about wasn't created by me, I've been ask to help sort it out.
The file is question is large and in random places are merged cells which contain images. (I've set the properties to move & size with the cells). What I ideally would like and presume VBA it the way to go is.
1. Unmerge the Merge Cells
2. Sort the Worksheet by Column A maintain Row Height formatting.
3. Re-Merged those cells that were merged.
Any ideas or tips please???
