I'm sure I know how to do this but for some reason I'm blanking...

The program is currently working in SheetB. I want to return the row number
for the ActiveCell in SheetA (without having to activate it). SheetA is in
the same open workbook, is visible, is NOT protected. I then need to
determine if the cell in column 5 for that row number on SheetA is blank.

Can someone please help me out in remembering how to do this?

Thanks in advance.