VBA Error on a Form

[RevJeff]

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.

Please Login or Register  to view this content.

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

[shg]

You can only use Select on the active worksheet.

Please Login or Register  to view this content.

[RevJeff]

That works great! Thanks!

[snb]

there's no need to select anything:

Please Login or Register  to view this content.