In My Application, i need to merge a few cells and at the same time use Wrap Text property to resize the cell for the content to fit exactly...
Can i get some help???

To do so with range A1:B12, try this:
------------------------
  With Range("A1:f2")
    .Rows.AutoFit
    .MergeCells = True
    .WrapText = True
  End With
------------------------

Remember that AutoFit only works as the spreadsheet setting does and too much content can confuse it. Another way to size it is to calculate the appropriate height yourself instead and use .height instead.

Thanks for the solution.
But my problem is,
the text is very large, so auto fit or wrap text is not working and to calculate the row height and assign it,the size of the text will be different for each sheet.
For each record in the table,i'm creating a sheet and displaying all the values and the content is not same in all the records, so i'm not able to assign the size manually to it.