VBA: Extracting Range from worksheet and inserting into userform
 

_What_is_the_\"ME\"_in_your_recommended_solution?_ It looks like thi
will probably work for what Im doing. Im just not sure If I understan
what the ME. is.

and 2nd....

ANYONE HAVE AN IDEA ON HOW TO SEACH AND RETREIVE THAT CUSTSSN FROM
COLUMN OF 300 OR MORE CUSTSSN'S

Thanks again, this is a a great site, Im glad I came across it

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27226

Extracting Range from worksheet and inserting into userform
 

Me refers to the object that the code is being executed from, so in a
userform it refers to the form, in a worksheet it refers to that worksheet.
It is a simple way of ensuring you are referring to 'this' container.

What does the second part mean exactly? To search you have a customer number
to search for, so do you just want the index within the customer numbers
where that item is found? Something like

iRow = Worksheetfunction.Match(sCustSSN,
Worksheets("Sheet1").Range("A1:A300"),0)
if iRow = 0 Then
MsgBox "Not found"
End If

--

HTH

RP

"Mcasteel" wrote in message
...

_What_is_the_\"ME\"_in_your_recommended_solution?_ It looks like this
will probably work for what Im doing. Im just not sure If I understand
what the ME. is.

and 2nd....

ANYONE HAVE AN IDEA ON HOW TO SEACH AND RETREIVE THAT CUSTSSN FROM A
COLUMN OF 300 OR MORE CUSTSSN'S?

Thanks again, this is a a great site, Im glad I came across it.


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile:
http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=272267