Shortcut of Merge Cell

[*Tamraiz*]

Umda Sharing,.......keep it up

[Nadeem_saqi]

aap macro record karain. Jo k built in toor par macro1 ka nam de ga isi ko rehne dain.
Short cut m q assign karain, aur macro ko stop kar dain.
Stop karne k baad macro k edit optionm jain aur ye code paste kardain.


Sub Macro1()
'

With Selection
        .HorizontalAlignment = xlCenter
        .MergeCells = True
    End With

ab ap jab bhe apni range select karian ge aur sirf ctrl+q press karain ge tu aap ke cell/range merge ho gain ge.

regards

Good work

[Kutkutariyaan]

Moved from.....Excel Course From Zaara Section