In the attached excel I would want to be able to merge two rows for certain continuous columns / range of columns. Say for Columns A to AF, I need to merge 2 rows of each of the columns.
Can you pls help with the code, where it says,
'VENDOR PART PAYMENT STATUS ACTIONS?
that is the portion of the code for this question.
Rather than
tryTarget.Offset (0): Target.Offset(1).Merge
Target.Resize(2).Merge
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote