Hi guys
I use this code but I still dont get the first cell in the same column and row 1
see code below:
Sub Langauge_Combination()
For Each sht In ActiveWorkbook.Worksheets
Set Rng = sht.UsedRange
Set MyRange = Rng
For Each MyCol In MyRange.Columns
For Each MyCell In...