Repeat VBA Formula For Multiple Rows

Hi All,

I was wondering if you'd be able to help me with the following.
I've been trying to lock a range of cells (H6-M6) whenever N6 isn't JM, DS, SD or SJ (This is a drop down menu). This has actually worked with the below code. However, I now want it to be applicable to the rows below that as well, so H7-M7 to be locked when N7 is not JM/DS/SD/SJ to row 60/70 more or less. I was thinking of copying the code and just changing the row numbers but I reckoned that's probably not the way to go.

Aditionally, I've been trying to clear out H6/I6/K6/M6 of any content as soon as JM, DS, SD or SJ is cleared from N6 and goes back to blank. And then for the rows below as well, obviously.

Would anyone be able to help me with both or one of these matters?

It would be greatly appreciated

Thank you

Please Login or Register  to view this content.

Hi there,

Sorry for the late response, was kept busy. This code seems to be getting me there but there's 2 things that are not going as I would like them to.

1. Rather than deleting the entire row contents up to row M, i'd like to see only columns H, I, K & M of the target row cleared. J & L have formulas in them which I need to keep there at all times.

2. The unlocking works perfectly, however I'd like the cells to re-lock after N is no longer showing JM/DS/SD/SJ.

Would you be able to help me?

Thank you!

You are a star!