If value in one row then return value in another row

[Glanza270bhp]

Hi All,

Another (very) newbie here!
I have a database where I want VBA to search all data in column j for a value and then column h and if both values are found in the same row, then return the words "high priority" in column k.

I have tried the below however I am getting 'type mismatch' error. Can anyone help please?

Many thanks in advance,

Rachel

StartRow = 1
LASTROW = Cells.Find("*", Cells(1), xlFormulas, xlWhole, xlByRows, xlPrevious).Row

For Row = StartRow To LASTROW Step 1


If Cells(Row, 10) = 30 And Cells(Row, 8) = 20 Then
Cells(Row, 11).Value = "HIGH PRIORITY"
End If


Next Row

 

[Joe4]

Welcome to the Board!

"ROW" is a reserved word. You should NEVER used reserved words as names of your variables, procedures, or functions, as this can lead to errors and unexpected results.
Try using something like "MyRow" or "r" or "rw" instead.

 

[Glanza270bhp]

Thank you Joe4 for your help however even changing the above as suggested, I am still getting the same error message?

Rachel

 

[Joe4]

Please post the entire procedure, and let me know exactly which line of code is being highlighted when the error occurs.
Also, is there a specific column that we can always look to in order to find the last row of data, for your purposes? I prefer to use that method instead of "Cells.Find(...", if possible.