loop through all files in a folder and run code to unmerge and shift

**ammartino44** · 05-05-2015, 04:47 PM

Hello. I have 100 files in a folder. Each file has one tab. Each tab has three tables. For the second and the third tables, I would like to CHECK to see if column B and C are merged...if not, ignore and go to next file. If they are merged, I want to unmerge and shift all of the cells to the right of B/C to the left one column. Please help.

**mikeTRON** · 05-05-2015, 05:02 PM

How do you determine if it is merged?

What part of the code are you needing help on specifically?

loop through all files in a folder and run code to unmerge and shift

LinkBack

Thread Tools

Rate This Thread

Display

loop through all files in a folder and run code to unmerge and shift

Re: loop through all files in a folder and run code to unmerge and shift

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA code for selecting a folder then search & open specified files in that folder

code to loop through all .docx files in folder

Choose folder & loop through all files to copy - folder is subfolder in network drive

[SOLVED] VBA Code to Move Individual Files from 1 Folder to a new Folder

VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Bookmarks

Bookmarks

Posting Permissions