+ Reply to Thread
Results 1 to 3 of 3

Search for data in row before activecell

  1. 11-06-2014, 02:36 PM #1
    vamosj
    vamosj is offline
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Search for data in row before activecell

    I am trying to search for data in a specific row in the columns before the activecell

    Say I am at Cell JH2 and I want to search for a certain bit of data in any columns before JH. This is what I have so far but it keeps moving to the right and not the left. Any assitance would be appreciated.

    Thanks in advance.

    Please Login or Register  to view this content.
    Janos S. Vamos
    Data Systems Technician/Fire Controlman PO1(SW/AW)
    US Navy Retired

    Remember, Record Macro can be your friend for figuring out solutions.

    Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
    Reply With QuoteRegister To Reply
  2. 11-06-2014, 03:02 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618

    Re: Search for data in row before activecell 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 11-06-2014, 07:01 PM #3
    vamosj
    vamosj is offline
    Forum Contributor vamosj's Avatar
    Join Date
    04-23-2004
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    294

    Re: Search for data in row before activecell

    Perfect, thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Selecting Activecell and cell next to the Activecell
    By Raghukumarn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2013, 06:32 AM
  2. [SOLVED] Using .Find to search data on sheet but to add new row from the ActiveCell code
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-08-2013, 11:21 AM
  3. [SOLVED] Set activeCell to first row of filtered data
    By bstubbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2013, 01:58 PM
  4. Output contents of Activecell when Activecell may be string or numeric.
    By jfriddle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 12:27 PM
  5. How to use Search, find last data point in column then select from that to ActiveCell
    By gpxfiles77 in forum Excel General
    Replies: 2
    Last Post: 06-25-2010, 12:11 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1