I have 28 columns from D9 to AE9 to hold day value. Suppose D9 is 29 Dec 2002 and G9 is 1 Jan 2003. I use VBA to merge D8 to F8 and Merge G8 to AE8 and place "Dec" and "Jan" in merged cells respectively.
Now I want two merged cells resumed to 28 cells when the date is changed.
[After Posted]
I found it was a wrong idea to place "Dec" and "Jan" in the middle using merged cell. I should use xlCenterAcrossSelection instead.
Any way I want to know how to split the cell after merged.
Any suggestion
Thanks
This message was edited by Emily on 2002-10-25 08:11
Now I want two merged cells resumed to 28 cells when the date is changed.
[After Posted]
I found it was a wrong idea to place "Dec" and "Jan" in the middle using merged cell. I should use xlCenterAcrossSelection instead.
Any way I want to know how to split the cell after merged.
Any suggestion
Thanks
This message was edited by Emily on 2002-10-25 08:11