Hi Rajan,
Its working fine now.
Thanks again.
Mangesh
On Thu, Jun 7, 2012 at 8:39 PM, Rajan_Verma wrote:
> I think I misunderstood your question , you can use this macro :
>
> ** **
>
> Private Sub Workbook_Open()
>
> Dim wksSheet As Worksheet
>
> For Each wksSheet In Me.Wo
I think I misunderstood your question , you can use this macro :
Private Sub Workbook_Open()
Dim wksSheet As Worksheet
For Each wksSheet In Me.Worksheets
If wksSheet.Name = "Result" Then
wksSheet.Copy ,
ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)