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
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
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 loo
;>", 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
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
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