Get row number of first empty cell in column and store that value in other cell

I want to find row number of first empty cell in column and store that row number in Cell Z1.

I tried with Following macro code but it goes into loop forever. As soon as it tries to set the value in Cell Z1 it again goes into worksheet_change event again and then again in for loop.

Please Login or Register  to view this content.

Please help to resolve this.

Thanks

(removed as too late)

No, this is not working as required.

I want to find first empty cell in given column, and that cell address (or just the row number) should be automatically typed to cell Z1.

for e.g

P1 = "ABC"
P2 = "XYZ"
P3 = "PQR"
P4 = (cell is empty)

So cell Z1 value should be set to 4 or P4. It should check and set on every worksheet_change event.

Originally Posted by PCI

See next code

Please Login or Register  to view this content.

sample screenshot attached

Attachment 675865