Macro Merge Cells with Values

I'm using Excel 2007. this code runs but need some tweking.
This macro merges worbooks inside my Temp Folder however I only want to merge only the cells with values. Or maybe select the entire sheet rather small Range like ("A1:M10").

Here is the code.

Please Login or Register  to view this content.