PDA

View Full Version : VBA to merge / unmerge identified rows when target is used



maatgie
03-10-2017, 12:00 AM
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.

mdmackillop
03-10-2017, 07:41 AM
Rather than

Target.Offset (0): Target.Offset(1).Merge
try

Target.Resize(2).Merge