Re: $$Excel-Macros$$ Re: overflow error issue

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

$$Excel-Macros$$ Re: overflow error issue

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

$$Excel-Macros$$ Re: overflow error issue

> > 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

$$Excel-Macros$$ Re: overflow error issue

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

$$Excel-Macros$$ Re: overflow error issue

> > 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 = ""