Results 1 to 4 of 4

Restrict a vba find to column a only

Threaded View

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Restrict a vba find to column a only

    This part of a code threw an odd anomoly when updating a record. It was because this apparently searches the whole used range

    How can I restrict the search to used rows in column A only

            lRow = .UsedRange.Find(What:=Me.MP1CPCtxt_2, After:=.Range("a1"), LookIn:=xlFormulas, LookAt _
            :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
            False, SearchFormat:=False).Row
            MsgBox lRow
    Any help appreciated
    Last edited by nigelog; 10-06-2017 at 12:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Restrict vallues in column
    By Anarchus in forum Excel General
    Replies: 2
    Last Post: 01-10-2017, 11:55 PM
  2. Restrict OpenEvent code to one column
    By stuartgb100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2015, 02:34 PM
  3. Restrict the macro in a particular column
    By cruise.alter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2012, 05:23 PM
  4. count in column and restrict output
    By excel_lover in forum Excel General
    Replies: 2
    Last Post: 09-24-2008, 12:48 PM
  5. restrict a specific word in any specified column
    By The Excel Boy in forum Excel General
    Replies: 8
    Last Post: 02-20-2008, 12:06 PM
  6. Restrict column adding and widening
    By mattsgr1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-07-2007, 07:31 AM
  7. is it possible to Restrict Find & Replace to 1 column
    By Simon in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-29-2005, 12:05 PM

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