Hi there,

Apologies if this question has already been raised, I couldn't find it when searching the threads.

I have input a BeforeSave function which only seems to work for the first row of data input (which starts on row 4), which is understandable based on the range I have entered. Can anyone tell me how do I make it repeat for all rows, please?

This is my first ever use of VBA and I found the below code on a forum after much searching and tweaked it quite a bit to add 3 conditions. It works to do what I want it to - recognising input in A4 and making the subsequent row cells mandatory - but only for the first row. I need this to repeat for all rows, indefinitely.

My current code is as follows:

Please Login or Register  to view this content.
Many thanks in advance