Hello there,
i need help trying to merge cells in the first column based on matching data in the third column using macros.
i have already made sorting according to the points and now i want to merge cells in column "a" in order to make some kind of ranking. If it's possible also to re-number column ''a'' so the result should look like in the second table:
Untitled.png
thanks in advance
Hi and welcome to the forum.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi, welcome to the forum
I would like to give a word of caution regarding creating and using merged cells. They cause all sorts of problems with formulas, we always advise against using them, if at all possoble
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
AlphaFrog :THANS A LOTIT WORKS PERFECTLY, BUT I HAVE ANOTHER QUSTION REGARDING VARIABLES. BEACAUSE I HAVE 20 SIMILAR TABLES AND I WANT TO MAKE EVERYTING IN ONE MACRO AND FOR EVERY TABLE I HAVE 3 VARIABLES WITH CONSECUTIVE LETTERS, WHAT IS NEXT WHEN I REACH ''Z"?
FDibbins: IN THIS CASE I DON'T HAVE FORMULAS INSIDE CELLS, SO THERE IS NO PROBLEM WITH MERGING.
It's not the formulas IN the cells that causes the problems, its referencing cells that are merged, that causes the problems
you're welcome.Originally Posted by nadiayo
alphafrog :thans a lot
I have no idea what that means.
Hi, my macro is a little bit longer and before this, it umerges all cells. That is the last part of it that i was missing.
Sorry, i was not so good in expressing what i mean. But i found the solution. I have 20 more tables like this, and for numbering and merging you gave me 3 variables (i, j, k). So for each table i needed 3 more letters and i reached the end of the alphabet
Sorry, i was not so good in expressing what i mean. But i found the solution. I have 20 more tables like this, and for numbering and merging you gave me 3 variables (i, j, k). So for each table i needed 3 more letters and i reached the end of the alphabet
Variables are reusable. You could simply use i, j, and k for the other tables as well. You would have to reset j back to zero for each table e.g. j = 0 at the start of a table's code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks