Identify Row Number based on Value in a cell and use that Row number in a Macro

I have Sheet with 40 employees who each proposes their work schedule, so I have to give each Employee access to the same sheet and want highlight and unlock only those cells that specific employee can use.

Each employee has to login from a drop-down (sourced from Sheet.Employee Master), so their unique Employee Number is in "A13" of Sheet.LOGIN

Can I identify the ROW number and then use that ROW number in a macro to highlight and unlock specific Range of Cells in Sheet.PROPOSED SCHEDULE?
---where "Sheet.LOGIN("A13") = (the value in the cell Col A:"row" of Sheet.PROPOSED SCHEDULE)


I have attached a scaled down version of the Workbook.


Following code is scaled down-- this is for Employee 02 who appears on ROW 16 of the sheet. (macro is same for each employee, just uses a different row)

Please Login or Register  to view this content.

Cells(x, y).Row

If you determine that cell x, y meets your criteria, that there will return the row number associated with that cell, you could use that as an integer in the rest of your code, IE

if cells(x, y) = whatever condition
a = cells(x, y).row
cells(a, y) = whatever you want to do to that cell.

Does that give you any ideas?

Hello johnnywinter,

I revised your code not to use "Selection"

Please Login or Register  to view this content.

Hello johnnywinter,

Maybe it didn't copy over correctly. I just tested this code and it compiled OK.

Please Login or Register  to view this content.

Hello johnnywinter,

I think I need to see your workbook. Can you post a copy of it for review?

Leith,

It is working perfectly. Here is the final code.

Thanks for all yoru help and patience.

JW

Please Login or Register  to view this content.