$$Excel-Macros$$ querry 5

2011-07-04 Thread Nemi Gandhi
Formula needed please. -- Nemi Gandhi 98204 92963 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ querry 5

2011-07-04 Thread ashish koul
try this Option Base 1 Sub nemi() Dim s(5) As String Dim z As Long s(1) = Very Good s(2) = Good s(3) = Better s(4) = Bad s(5) = Very Bad For i = 1 To 5 On Error Resume Next Sheets(1).ShowAllData z = Sheets(1).Range(f65356).End(xlUp).Row + 1 Sheets(1).Range($A$3:$e$