Merging Cells Using Excel-VBA

[vidya lakshm]

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

[Bob Phillips]

This is a duplicate post and I have already answered your previous posting.

[Simon Lloyd]

isn't this question based on the same one answered here! (http://www.vbaexpress.com/forum/showthread.php?t=33950) by xld?

[Simon Lloyd]

This is a duplicate post and I have already answered your previous posting.Woah!, mind my toes :)

[Bob Phillips]

Well, if you will stalk me ...

[vidya lakshm]

Hi,
Yes. I tried to apply the same to my existing code.But it is not working.
I also get a runtime exception. Hence thought of posting the requiremnt very clearly.

Please help me in arriving at a solution for this problem.

Regards
Vidya

[Simon Lloyd]

Well, if you will stalk me ...Damn camouflage isn't working too well then!

[Bob Phillips]

That should not cause you to start a new thread, the old thread was perfectly fine for cointinuing the discussion, and it has context.

If anything, your requirement is less clear this time.

[Simon Lloyd]

Thread closed!

Vidya, please use your original thread as indicated by xld.

[Bob Phillips]

He has also taken to cross-posting now, at XtremeVBTalk. That tread has been moved, but he doesn't deserve any help.

[Simon Lloyd]

Thanks he's getting a warning right now!