Worksheets("Summary").Cells(nNextRow, "H") = Format(.Cells(nRow, "AE"), "mm-yyyy")

giving 12-Jul

But i need Jul-12 format..

can you please help