Murray Brown
asked on
Excel VBA Merge Cells
Hi
What Excel VBA would I use to do each of the ollowing Excel merges
Merge & Center
Merge Across
Merge Cells
What Excel VBA would I use to do each of the ollowing Excel merges
Merge & Center
Merge Across
Merge Cells
ASKER
Hi. Thanks
I had done that and post the question because step 1 and 3 seem to be exactly the same,
I had done that and post the question because step 1 and 3 seem to be exactly the same,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see. I had assumed that that first bit would have happened for all the merge types but woke up this morning realising that it might not, so thanks very much for the clarification...
to find out about commands like these, fire up the macro recorder and use the commands one after the other. Then stop the macro recorder and see the code:
Open in new window
The macro recorder always uses the Select statement, which you can trim from your final code, like
Open in new window
cheers, teylyn