How do I add to this code to say if row F says B then lock rows G and H?
I managed to do it earlier but caused another problem so had to start again. I seem to get close but can't get it correct!
Please Login or Register to view this content.
How do I add to this code to say if row F says B then lock rows G and H?
I managed to do it earlier but caused another problem so had to start again. I seem to get close but can't get it correct!
Please Login or Register to view this content.
lastat,
Maybe something like this?
Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).
Please Login or Register to view this content.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks, I was trying to add the ElseIf already. With this I get the Compile Error: Else without If and I don't know enough for this to make sense to me
You can also use a Case statement as below.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks