Code:
                Range("A2:D2").Select
                With Selection
                    .HorizontalAlignment = xlCenter
                    .VerticalAlignment = xlBottom
                    .WrapText = False
                    .Orientation = 0
                    .AddIndent = False
                    .IndentLevel = 0
                    .ShrinkToFit = False
                    .ReadingOrder = xlContext
                    .MergeCells = True
                End With
                Selection.Merge

'ive been using that code merge a cell. but my problem is the cell, is possible to use "1" instead of "A" in defining cell range ("A22")?

because sometimes, i don't know what exact row or column to be merge.. it will base on the For Next statement of the code.