Dimming Long still gives error.

"Joel" wrote in message
...
when you declare a variable as an interger its range is -32,768 to 32,767.
Use Dim Long or Dim double for larger values.

"scott" wrote:

I don't quite understand your question. Perhaps I should explain my
problem
again. My data form will accept entries for ColA and/or ColB.

When the user enters a value in the form for either column and clicks ok,
a
new row is inserted at row 2 and then the new values entered in the form
are
inserted into row 2. I need someway of matching the columns that have
matching numbers, but leave a blank in either column next to a value that
has no matching value already entered.

So, my data range could end up looking like LISTING 2. ColA will always
have
more entries, but either column can contain non-matching values at
anytime.


LISTING 1:

ColA ColB
45
50
60 60
75


LISTING 2:

ColA ColB
45
35
50
60 60
75
90



"MP" wrote in message
...
hint
what is the allowable range for an integer?
:-)

"scott" wrote in message
...
I'm still getting the Overflow error with your code.

I'm using call InsertMatch("196000") in the command window.

"Joel" wrote in message
...
Sub InsertMatch(iValue As Integer)