Hi
Integer has as limit 32767 more than it it will show overflow error so you have
to use long variable.
ThanksRavinder Negi
On Wednesday, February 24, 2016 1:11 PM, Kat wrote:
Hi Mandeep,
I don't know how to use VLookUp function for my situation. I was wondering
whether would you m
Hi Mandeep,
I don't know how to use VLookUp function for my situation. I was wondering
whether would you mind showing me how to use VLookUp function according to
my code?
Cheers
On Monday, 22 February 2016 20:57:58 UTC+8, Mandeep baluja wrote:
>
> Will you please let me know why you're not u
>
> Will you please let me know why you're not using a simple vlookup
>> function,index match for the same it would be more faster than this to
>> search using find method one by one, while defining the value to integer it
>> doesn't matter how many rows of data you have 1 to 5 lac it will work
Hi Mandeep,
I have defined the variable to long for the whole program and it takes very
long time for running. Also, for the code below, if I use integer, I will
get overflow error. If I change variable to long, I will get
application-defined or object-defined error. Can you help me on this is
>
> Define your variable as long !!
>
Sub dnew()
Dim i As long
Dim lrow As long
lrow = Sheets("to").Range("C" & Rows.Count).End(xlUp).Row
For i = 2 To lrow
If Sheets("to").Cells(i, 2).Value = "up" Then
Sheets("to").Cells(i, 2).Value = ""
She