**RESOLVED** MERGE & SPLIT cells in excel using VB

Hi guys,

i have problem in merging and spliting cells in excel sheet.
i have a template and i am using 8 columns.

either of the below solution is ok for me

Option 1
i want to merge 4 columns each (making 8 columns to 2)

Option 2
right now i am able to merge whole row altogether.
is it possible to spli the same row into 2 columns ?

pls suggest

thanx in advance

i tried myself and could do the merging....

thnx guys ! ! !