Hi experts,

I do have a following code for copying a value from another sheet..

{code}
Worksheets("Summary").Cells(nNextRow, "N") = .Cells(nRow, "D")
{code}

the above is copying proper the value of D...

Cells(nRow, "D") is date column. I need to extract mont-yy format data only...

for example if D = 27/8/2012 then i should extract in the format of Aug-2012 and asign that value to left side row...

how can i change above for my requirement..

thanks