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.

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

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

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.