[Caprica6]

Hi,

I want to be able to split a cell if there is already text in it. I am sure this can be done but can not find any code to do it.

Can someone point me in the right direction ?

Thanks

[Caprica6]

I have tried

Selection.Cells.Split NumRows:=1, NumColumns:=3, _
		MergeBeforeSplit:= True

but I get the error "object does not support this property or method"

[firebolt]

mhm... where is the error at?

Also.

How do you want it to be split? Not really getting that.

[Caprica6]

sorry not feeling well today :-(

What I am doing is if the user right clicks on a cell in the worksheet I display a form for the user to select something from a combobox.

If there is text already in the cell I want to retain the existing text, split the cell and add the new text to one of the split cells.

I get the error object does not support this method on this line of code

Sheet1.Columns.Cells(intCurrRow, intCurrColumn).Split 1, 1, True

Now I know this means that this method is not in the object collection so I am not sure what the code should be.

I am using Office 2003.

Hope this is a bit clearer let me know if not.

Thanks

[June7]

According to Excel help you cannot split individual cells. You can merge cells and then later using VBA code unmerge them. Sounds like you simply need to structure your worksheet with cells intended to be populated with the user-selected data.

Instead of popping up a form with a combo box you could use Data Validation, which is a property of the specific cell where you want the data to display.

This post has been edited by June7: 05 April 2009 - 06:24 PM