forest1959
New Member
- Joined
- Mar 16, 2010
- Messages
- 30
- Office Version
- 2016
- Platform
- Windows
Searched the web for an answer to this but finding it hard to put into words what i need so i will do my best to explain.
If i have the number "2" in cell "A1", I want some VB that will merge cells B1 and C1 (2 columns)
then
If I have the number "4" in cell "A2", I want some VB that will merge cells B2, C2, D2 and E2 (4 columns)
and so on till the loop comes across an empty cell in column A
There will be no physical data in any other row other than "A"
In summary, I would like some VBA to merge the amount of cells from column B onward's depending on the number inputted in column A
I hope this explains enough
Regards
If i have the number "2" in cell "A1", I want some VB that will merge cells B1 and C1 (2 columns)
then
If I have the number "4" in cell "A2", I want some VB that will merge cells B2, C2, D2 and E2 (4 columns)
and so on till the loop comes across an empty cell in column A
There will be no physical data in any other row other than "A"
In summary, I would like some VBA to merge the amount of cells from column B onward's depending on the number inputted in column A
I hope this explains enough
Regards