Hi,
I created a Search Form on one sheet and I am trying to get it to search a range of data on a differant sheet. When I click the Search button, I get the following error message:
Run-time error '1004':
Select method of Range class failed.
With rng
Set c = .Find(strFind, LookIn:=xlValues, lookat:=xlPart)
If Not c Is Nothing Then 'found it
c.Select <-------------------- Highlighted
With Me 'load entry to form
.TextLastName.Value = c.Offset(0, 1).Value
.TextFirstName.Value = c.Offset(0, 2).Value
.TextMI.Value = c.Offset(0, 3).Value
The button 'Single' that launches the Form 'UserForm3' is on the "Single Claims Report" sheet. The Form is supposed to be searching the data on the "ClaimsData" sheet. If I launch the Form from the "ClaimsData" sheet, it works great, but I need it to launch from the "Single Claims Report" sheet.
Any help would be greatly appreciated!
Thanks,
Jeff
Bookmarks