Vba multiple condition

Hi,

I have created a VBA with the condition whereby if the nos are greater than/equal than 31 and less than/equal to 46, the value will return 1 in column L.

But now, I want to add another condition whereby this will only be apply if column D is AA. Can anyone assist me on how to add that condition below?

Please Login or Register  to view this content.

Works like a charm!!!