Select range of data dynamic

[Florian56]

Hi, i have a problem on VBA. I'm really new to this.

The program need to do the following steps :

Select data from B2 to O3 (Those cells are merged and there is a title centered to the left).
Add P2 to P3 to the selection
Merge P2:P3 to B2:O3 (the previous selection)

And i need to do it dynamically : If executed again, the macro need to select data from B2 to P3
Add Q2 to Q3 to the selection
Merge Q2:Q3 to B2:P3

Etc...

Note that the data is not in a table but in cells.

Can i have help?

Thank you

[Norie]

How exactly are you merging?

If you merge an entire range like B2:O3 you will lose all the data apart from the value in B2.

[Florian56]

Hi,
I merge the data with the option : merge in excel (i dont center them).
Its letters that i merge (it's a title with blue font) so they dont disappear.
The title should extend with the table, everytime i add a column.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[Florian56]

Here it is