Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi, sorry to bother you with this little problem... I am writing a word document from Excel by VBA code, and in the word document there is a table with two rows. In the first table row, there are four cells, in the second row there are five cells (after merging cell(1,1) and cell(1,2)). Now I want to merge cell(1,4) and cell(2,5) into one. To do this I suppose I have to select or activate the cells first(maybe not?), but how to? I am trying to somehow define a range of cells, but have not succeeded yet.. :( This (bold text) seems not to be the correct syntax ?? Code: -------------------- Set myTable = wordApp.ActiveDocument.Tables.Add(Range:=wordApp.S election.Range, NumRows:=2, _ NumColumns:=5, DefaultTableBehavior:=wdWord9TableBehavior) .... ...merging cell(2,1) and cell(2,2) and writing to cells.. .... *myTable.Range(myTable.cell(1, 4), myTable.cell(2, 5)).Select Selection.Cells.Merge* -------------------- Someone have a clue?? Best Regards Siri -- SiriS ------------------------------------------------------------------------ SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995 View this thread: http://www.excelforum.com/showthread...hreadid=538814 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
troubleshoot merge cells - checked protection. Why is icon dim? | Excel Discussion (Misc queries) | |||
in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) |