Re: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread dguillett1
04, 2012 8:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: V lookup using macros I know this doesn't necessarily address your specific problem, but I have a recommendation for you. If your files are 4Mb+, then that implies thtat you have a lot of rows. in which

Re: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread Paul Schreiner
ords.Count End Function   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: nitin arora To

RE: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread Rajan_Verma
You can use this in VBA. strResult=Application.Vlookup(LookUpvalue,LookupRange,ColNumber,MatchType) Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of nitin arora Sent: Jan/Wed/2012 11:01 To: excel-macros Subject: $$Excel-Macros$$ Fwd: V

Re: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread dguillett1
;>", Operator:=xlFilterValues Cells.Copy Sheets("Validation Not Done").Range("a1") .AutoFilter End With End Sub Don Guillett SalesAid Software dguille...@gmail.com From: nitin arora Sent: Wednesday, January 04, 2012 7:19 AM To: excel-macros@googlegroups.com Subject

Re: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread nitin arora
Hi Noorain, I am extremely sorry for the mistake. However all the files that I have are of more than 4 mb in size and gmail is not allowing me to send more than 4 mb of data. I am pasting the codes for macro 3 used in the sheet . Please let me know if there is any other way by which i can upload t

Re: $$Excel-Macros$$ Fwd: V lookup using macros

2012-01-04 Thread NOORAIN ANSARI
Dear Nitin, Attached File is in protected mod, we are unable to view Macro 3 On Wed, Jan 4, 2012 at 11:00 AM, nitin arora wrote: > > Hi, > > I am facing a problem with Macro 3 in the sheets attached. At times the > macro woks fine and at times it does not. The reason for the same is that > whe