Re: Macro Find Empty Cell In Row Above
Apologies for my duff code, I made a couple of errors as I was in a bit of a hurry. I've just looked at Kenneth's code, which appears to work. I just used your example of Words1-9 in the attached sheet. When running Kenneth's code, the macro does exactly as I assumed you wanted. Have a look at the sheet and let us know if we've mis-understood your request.