Merge cells convert to normal

[makinmomb]

I have following data

TRANSROAD - 01/06/18
JOB NO:	PORT CHARGES	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0418	KALONJI - P/C	76	76	-			-
TR-0460	FALAY - P/C	117	117	-			-
TR-0454	PEARL - P/C	117	117	-			-
TR-0377	LUNGA - P/C	117	117	-			-
TR-0184	OM METAL - CHEMICAL - REM+STOR	384	384	-			-

<colgroup><col><col><col span="6"><col></colgroup><tbody>
</tbody>

 

[makinmomb]

I want the macro to swim into header that have merged cells and bring that data to a1 , so that i can do some data
pull since the merged cells is bringing problems for data pulling

 

[makinmomb]

Search range entire sheet

 

[MARK858]

Sub Unmerge()
Cells.UnMerge
End Sub

 

[makinmomb]

mark858 thank you it did exactly what i needed , cant imagine how long this would have been without a macro

 

[MARK858]

cant imagine how long this would have been without a macro

2 seconds, you click the square where the column letters and row numbers meet and click the merge and center icon

Anyway happy it worked for you