Re: $$Excel-Macros$$ Urgent help on simple macro

Try this: Sub Tisp2Core() Dim lngLastRow As Long, i As Long Application.Goto Reference:="R6500C2" lngLastRow = Selection.End(xlUp).Row Do If UCase(Range("B4").Offset(i, 0).Value) = "TISP" And _ UCase(Range("B4").Offset(i, 3).Value) = "CORE" Then Range("

Re: $$Excel-Macros$$ Plz needful request

YOu need a Dlookup or a Custom List. On Wed, Nov 18, 2009 at 2:18 AM, Anil Saxena wrote: > > Hi All > > Plz suggest me how to use formula like these e. g. when i written any names > automatically put value. > > > >Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40 > > -- > > -

Re: $$Excel-Macros$$ Problem with Calling a Sub in a Module from a Form

You could just use Global variables. On the On_Click event set the globals = to the value in the textboxes on your form. On Mon, Nov 16, 2009 at 6:50 AM, laudes wrote: > Thank you a lot for your help. It worked with the "call", and sorry > for the delay. > > > On 8 Nov., 00:20, Fabio Lemos wrote

Re: $$Excel-Macros$$ QUERY 4 - CONDITIONAL FORMATTING & FILTER

Your question makes absolutely no sense. On Mon, Nov 16, 2009 at 8:26 AM, big smile wrote: > Respected Excel Friends, > > Attached please find the excel sheet -- in which i have explained my query. > > Try to resolve it > > Thanks > > J C SHAH > > -- > > -