Re: $$Excel-Macros$$ Macro Single code require for if condtion

2014-03-04 Thread Prafull Jadhav
Thanks a lot Sir.. Perfect! Regards, Prafull Jadhav 9920553518 On 4 March 2014 17:21, Paul Schreiner wrote: > You could replace your If/ElseIf/Endif statement with a Select Case > Statement: > > Select Case Selection.Offset(0, 2).Value > Case "GURGAON(DELHI-NCR)", "MANESAR(HR)", "ROHAD(

Re: $$Excel-Macros$$ Macro Single code require for if condtion

2014-03-04 Thread Paul Schreiner
You could replace your If/ElseIf/Endif statement with a Select Case Statement:   Select Case Selection.Offset(0, 2).Value     Case "GURGAON(DELHI-NCR)", "MANESAR(HR)", "ROHAD(HR)"     Selection.Offset(0, 12).Value = "Gurgoan-Rohad-Pathredi"     Case "HSR-CRD(HR)", "HSR-GET HOSTEL", "HSR-HRD(HR)