$$Excel-Macros$$ querry 5
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
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$