Assign and found range to a variable

**duckboy1981** · 06-26-2009, 10:11 AM

Hi all,

I am using a standard find routine to find the first match for a set of search critera. I then wish to display this crieria in a user form, but I am unsure of how to extract the range of the find result in to suitable variables to do this.

This is the code I am using.

Please Login or Register  to view this content.

So for example, if I was to search 'Gould' and the rusult was found in "C493", I would like to assign the values in "A493:R493" ('txtDateOpened.text = range("A493").value'), but obviously the result will not always be "C493". Hope that makes sense!

Any help is greatly appricated.
Thanks.

**romperstomper** · 06-26-2009, 10:19 AM

You can use rngFound.Row to get the row of the found item, then use that with the Range property:

Please Login or Register  to view this content.

for example.

**duckboy1981** · 06-26-2009, 10:55 AM

Sorted, thanks!

Assign and found range to a variable

LinkBack

Thread Tools

Rate This Thread

Display

Assign and found range to a variable

Re: Assign and found range to a variable

Re: Assign and found range to a variable

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions