Results 1 to 11 of 11

Find function and Intersect

Threaded View

mpalm Find function and Intersect 05-27-2011, 11:33 AM
Colin Legg Re: .Find function problems 05-27-2011, 11:44 AM
mpalm Re: .Find function problems 05-27-2011, 11:50 AM
Colin Legg Re: .Find function problems 05-27-2011, 11:53 AM
mpalm Re: .Find function problems 05-27-2011, 12:04 PM
Colin Legg Re: .Find function problems 05-27-2011, 12:13 PM
mpalm Re: .Find function problems 05-27-2011, 12:30 PM
Colin Legg Re: .Find function problems 05-27-2011, 12:35 PM
mpalm Re: .Find function problems 05-27-2011, 12:48 PM
Colin Legg Re: .Find function problems 05-27-2011, 12:52 PM
mpalm Re: (<-excellently) .Find... 05-27-2011, 01:04 PM
  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    48067
    MS-Off Ver
    Excel 2007
    Posts
    12

    Find function and Intersect

    Hey Guys,

    I'm trying to use the .Find function to find a specific value 'tbName' in a Range that I set in the worksheet: "Income"

    the error is "application defined or object defined error" on the 'Set' line.

    I want Rng to be the Cell address where the tbName value is found

    Set wks = Worksheets("Overview 2011")
    
    ' frmAddNewItem.cboType.Value="Income"     
    Set Rng = wks.Range(frmAddNewItem.cboType.Value).Find(frmAddNewItem.tbName.Value).Address
    Last edited by mpalm; 05-27-2011 at 01:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1