+ Reply to Thread
Results 1 to 4 of 4

Match function in VBA, for finding a cell

  1. #1
    Registered User
    Join Date
    08-06-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Match function in VBA, for finding a cell

    Hello,

    So, this is how it goes: I want to use the cell(row,column)=now() version of a time stamp, but I am using 2 lists to time stamp a specific person. I figured out the since the column is going to be the *Time In* column, all I need to do is find the row. That is as simple as a match command. This is what I have gotten so far, and it's pulling a "Sub of function not defined" Error while highlighting cell.

    Please Login or Register  to view this content.
    If you guys can help, help a poorworker out. Thanks in the front.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Match function in VBA, for finding a cell

    Hi
    This is more like the syntax you need:

    Please Login or Register  to view this content.
    Declare the row as a variable and also you need to add Ranges to your code. Also the ranges would be better with a sheet reference in front:

    'Worksheets("Sheet1").Range("B4")' for example.

    Hope this helps.
    DBY

  3. #3
    Registered User
    Join Date
    08-06-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Match function in VBA, for finding a cell

    I can program in a calculator, but I forget to put in variable code into excel..... Darn.

    Thank you for taking a peek at my question and helping me with the extra code

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Match function in VBA, for finding a cell

    You could have used the Match Function within the Cells() as a row number but variables only need to be declared once and can be used easily again in the code. You could also declare the Worksheets as variables and not have to keep referencing them in full. Thanks for the Rep mark.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index-Match function not finding matches with newly pasted values
    By murp5972 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-04-2015, 03:44 PM
  2. [SOLVED] Finding start and end columns using MATCH function
    By Pedsdude in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-23-2014, 07:04 AM
  3. Problem Finding Data in Multiple Columns Using Match Function
    By joshc22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2012, 04:26 PM
  4. Finding the Nth Occurance in a Match Function
    By kakron21 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 05:48 AM
  5. Match Function - Finding The Last Instance
    By BenRoylance in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2010, 05:37 AM
  6. Offset function with nested match function not finding host ss.
    By MKunert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06:50 PM
  7. Finding two variables on the same row to match function
    By Werner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2005, 04:37 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