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

VB Code:
  1. wSheet.Range("A4", "G4").Merge

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

Thanks.