Split Cells in Excel

[Hojo]

Hello All

I am making a report in excel and am manipulating the first few rows for titles and details of the report.

I was wondering how would i be able to split 1 cell into 2 or 3

Reason I have a row of 7 columns and i want to create 3 equal coloumns so i merge the row into one cell

wSheet.Range("A4", "G4").Merge

then i want to split this new cell into 3 but i do not know the syntax.

Thanks.

[jcis]

Split cells in Excel? I don't think it's possible, even in Excel itself. But, if you know the way to do it in Excel (manually), then save the Macro and take a look at the VB editor to get the code generated.

[Hojo]

jcis

Thats what i was afraid of. I'm not sure how to do it maually in excel and i was hoping that wasn't because it couldn't be done.

Unless anyone else has any ideas i guess i'll have to re evalute my layout.

Cheers jcis

[jeroen79]

What you coul do is insert a column next to the cell's column.
Then join the cells above and below the cell with the cells in the new column.

[Hojo]

Top Idea Jeroen79

I have already changed the layout to not need to do this, but in the future if i have to have a report as such, i'll give it a try.