Good Evening,

I need your help to rename a sheet base on the name.


    If Sheets(("Order_Export") Or ("ExportDataOne")).Name = False Then
     MsgBox "Wrong Spreadsheet ....."
    End If


Sheets("Order_Export").Select
If  Sheets("Order_Export").Name = "Request For Quotations"

Or 

If  Sheets("ExportDataOne ").Name = "Request For Quotations"