How to Marge the cells automatically

[Sanjibghosh]

Hi All,

i want to marge cells automatically using VBA code when i filter the BD names. For example, if i select the BD name like "Sam" from drop down then the "N6:N16" & "O6:O16" cells are marge and if i select the name like "Ryan" then the "N6:N17" & "O6:O17" cells are marge. last row number depend on the end of the data row number.
Please help me how to solve the issue

[davesexcel]

This should do it.

Please Login or Register  to view this content.

[Sanjibghosh]

Thank you so much...Now i want to create border around the marge cell. but i am getting an variable error in this code. please help me where i have done the mistake

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

[Roger Govier]

@sanjibghosh

Just modify the code as follows

Please Login or Register  to view this content.

[Sanjibghosh]

i am getting run-time error '424' object required with this code. please help to resolve

Please Login or Register  to view this content.

[davesexcel]

Can you not indicate where you get the error?

[Sanjibghosh]

Extremely sorry... i did some mistake in this code.

Thank you so much to help me.