Merging Cells Using Excel-VBA

**vidya_lakshman01** · 09-09-2010, 07:45 AM

Hi,

Please refer the attachment .It has a Button in the sheet4.On the click of the button 3 sheets get created.

My Requirement is :

I need to merge the cells from Column F-J based on the no. of validations that a particular filetype(Column C) has.
Eg: In module1,

filetype doc has validation1-validation 5.So merge them and give the method name.
Similarly xls has validation1-Validation3.So merge them & give the method name as method1 in sheet1.

This needs to be repeated for Module1,2 & 3.

Kindly help me in figuring out how this can be done at the earliest.

Regards
Vidya

**davesexcel** · 09-09-2010, 07:57 AM

It's a bad idea to merge cells as you have been told before.
Why are you so set on merging cells?

**vidya_lakshman01** · 09-09-2010, 08:04 AM

I do understand that merging may not be a good idea.

But the requirement is like that. So...

Also, I am getting a runtime exception when I execute the code.
Request you to help me out.

Regards
Vidya