How to code repeating vba formatting/cell merging

Please Login or Register  to view this content.

'This code module creates a summary sheet for weekly deliveries to various welfare agencies around our valley. We make an
'excel delivery sheet
'for each agency as we deliver to them, and I'm trying to summarize our weekly deliveries from those sheets for inventory control and etc..
'The delivery sheets consist, first, of the agency name info followed by item quanities and descriptions. There are 12 or fewer items
'per sheet. The delivery sheet info is concatenated into four columns on the summary sheet. The agency info requires more space so needs
'to go into merged cells. So then the agency info is in the merged cells followed by the item quanities and their descriptions'

HERE IS MY PROB. - the code in the next line properly merges cells a1:d1 which holds the agency name for the first delivery
'sheet processed but I need to change it/something to format/merge the cells used for subsequent agency names as their sheets are
'processed. The deliveries are not all the same length so can't just format every nth row. Some agencies order more stuff than others.
'The variable h1 is a counter placed on the "sumry" sheet which points to the last used row, so I add one to point to the next row available.
'I'll strive for more coding elegance after I get this $*@%#& thing working. I now open each delivery sheet file manually. I'll next try to
'step through the folder and open and process each file automatically. Typically about a dozen delivery files per week.

Please Login or Register  to view this content.

Thank you, thank you for any suggestions.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you this time. In the future, please read the forum rules and abide by them.)