How to merge dynamic range of cells?

[Swagata]

Hi,

I have an sheet where There are two columns Script_Name and Steps. Steps column would contain have numeric value, i.e. 5 . I want to write a macro which will take the value from Steps column (5 in this case ) and will merge that many number of rows in both Steps and Script_Name column.

Can anybody help me with this? Appreciate your help!

Regards,
Swagata

[patel45]

attach please a sample file with data and desired result

[Swagata]

Please find the attached sample excel. I want to pick the value from Steps column (5 in this case) and merge that many rows dynamically for Steps and Script_Name column.

[patel45]

very heplful sample !!!

[HaHoBe]

Hi, Swagata,

I doubt it to be a good idea to work with merged cells (youŽll certainly will run into other issues when working with VBA) but you may try it like this:

Please Login or Register  to view this content.

Ciao,
Holger