ERROR : Select Method of Range Class Failed

**Logit** · 08-23-2016, 03:53 PM

I'm receiving an error message I can't work through :

Trying to complete a search of data on Sheet #1 from Sheet #2 using a User Form. (See attachment) . Once the search is complete, the user should be able to scroll through the results from the Listbox and have the individual rows appear in the text boxes below. It works fine from Sheet #1 but not from Sheet #2.

I'm certain it is a minor fix but I can't figure it out after having tried several different references to Sheet #1. Any assistance you may give is
greatly appreciated.

Thank you so much !

Please Login or Register  to view this content.

**Norie** · 08-23-2016, 04:09 PM

You don't really need that line of code so you could just remove it.

PS There's no attachment.

**walruseggman** · 08-23-2016, 04:13 PM

Agree with @Norie, just remove it. However, if it hangs there, it's gonna hang in your with statement, too, as that's the same syntax.

Guessing strAddress isn't a string that could represent a range, but hard to say w/o the attachment.

**Logit** · 08-23-2016, 04:31 PM

Well .... my computer screen says the attachment was sent. Let me try again ....

**Logit** · 08-23-2016, 04:36 PM

Well ... Ok Then ....

I commented out that line and it works ! Now why didn't I think of that ?

Thanks guys. Appreciate the help.

I'm learning ....

**NoSparks** · 08-24-2016, 10:09 AM

Hello Logit

Mind if I ask how you're getting the data for your Prefix sheet ?
In particular the country and associated continent.

I was helping out a HAM operator a while back (who used Grid rather than ITU or CQ zones) and
could pull all information automatically from the internet when a call sign was entered into a user form
except for the continent. Had to have a table on a sheet for continent from country.

Thanks
NoSparks

ERROR : Select Method of Range Class Failed

LinkBack

Thread Tools

Rate This Thread

Display

ERROR : Select Method of Range Class Failed

Re: ERROR : Select Method of Range Class Failed

Re: ERROR : Select Method of Range Class Failed

Re: ERROR : Select Method of Range Class Failed

Re: ERROR : Select Method of Range Class Failed

Re: ERROR : Select Method of Range Class Failed

Thread Information

Users Browsing this Thread

Similar Threads

getting error : select method of range class failed

[SOLVED] error 1004 select method of range class failed

Error Message:Select Method of Range class Failed

Select Method of Range Class failed error 400

[SOLVED] Select method of range class failed error

Select method of Range class failed" error message

select method of range class failed error

Bookmarks

Bookmarks

Posting Permissions