Hi,
I have posted my query in MrExcel Forum too: https://www.mrexcel.com/forum/excel-...ml#post5028028
I have a code that successfully merges data from a specific named sheets of multiple workbooks into specific master workbook sheet.
However, the code merges empty rows too that have some sort of formatting in them. In my case, the source sheets have boderlines without any values in the empty rows. I tried using SourceRange.Range(FirstCell & ":" & RDB_Last(3, .Cells)).ClearFormats but it fails to resolve the problem.
If I manually clear the formatting from the source files, save the file and then run the code it works right. But that's not possible in real time scenario.
A novice to VBA. Please help. Thanks in Advance.
Note: Please change MyPath in the code. . Attachment option is not working for me to provide the files. So I have shared the Zip Folder on my G Drive.
Folder URL: https://drive.google.com/file/d/11XE...ew?usp=sharing
The Code:
RDM_Last Function is used to determine the last row, cell with value. Please find the code at the very bottom of the provided URL: https://www.rondebruin.nl/win/s3/win008.htm
Please Login or Register to view this content.
Bookmarks