Re: merging cells in excel
Did you get that code from recording a macro?
It shows ".MergeCells = False" which will not merge the selected cells.
Thread Moved
Re: merging cells in excel
yes i got this to macro.. some code from macro works on creating an excel file?
Re: merging cells in excel
You want to create an excel file now? But from where? Excel VBA or another programming language?
Create Excel Workbook
http://www.vbforums.com/showthread.php?t=442132
Re: merging cells in excel
The code posted in post 1 is absolutely correct to merge cells... Can you exactly explain...
1) Where are you running the code from?
2) Which sheet are you applying the merge in