Hi All, I am new to VBA. Need some help in writing a macro which merges number of cells downwards based on a value entered in a specific cell. For example, if cell A1=5 then I want to merge B1:B5 or any other range. Request you to provide a full solution with codes.
Does this help?
Please Login or Register to view this content.
Hi John, yes it works. I found another method as well, but yours looks better and short. And I like the macro name. :D :D. Thanks for the help!
Please Login or Register to view this content.
THis is not an answer to your question, but some advice. You should try to avoid merging cells whenever possible, they cause all sorts of problems with formulas, and there are often other ways around merging
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
Hi Ford, advice taken. Actually this code will be a part of a bigger macro which will make calculations and prepare a grid view based on the inputs. Must say, this site is quick in responses.
As long as you are aware of the potential pitfalls
We try to be on the ball
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks