Results 1 to 9 of 9

VBA find row for double conditions

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    Paris
    MS-Off Ver
    2013
    Posts
    35

    VBA find row for double conditions

    Dear all,

    I would once again really appreciate your help on the following below:

    I need to find the row number when two conditions are met:

    1. First, find in column 23 the value x
    2. Second, find in column 91 the value shop

    Wheb I run the code, it doesnt work yet. Do you have any tips?

    Thanks!!

    If wscalc.Columns(23).Find(x, , , xlWhole)), , , xlWhole) And wscalc.Columns(91) = shop Then
    
    r = activecell.row
    Last edited by jeffreybrown; 02-17-2018 at 06:51 PM. Reason: Please use code tags!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Double if conditions to match then add to an existing dictionary
    By KAYABRFR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2018, 11:48 AM
  2. selection on double conditions
    By petenc in forum Excel General
    Replies: 2
    Last Post: 05-12-2017, 03:26 PM
  3. [SOLVED] Using find replace to first find two double quotes and replace with a single double quote
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2015, 10:13 AM
  4. Replies: 0
    Last Post: 08-26-2014, 08:04 AM
  5. [SOLVED] Double find?
    By PyhaWaim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2014, 10:49 AM
  6. Change cells back to original conditions by double clicking another cell
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 10:21 AM
  7. double conditions for CountIf
    By Knud Gentz in forum Excel General
    Replies: 3
    Last Post: 04-03-2005, 06:06 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