Find Nth empty cell

[CDandVinyl]

I use this code to find and select the first empty cell in Column D :

Please Login or Register  to view this content.

This works fine and selects the first empty cell in D when I open the WS.

I'd like to amend it to find and select the 14th empty cell in D. Can someone suggest a way to adapt my code to do this?

Grateful for any help.

[vba_php]

if you want the easiest way, in terms of added code to what you already wrote, why not do this and count?

Please Login or Register  to view this content.

[CDandVinyl]

Yes , that's done the job. Many thanks.

[vba_php]

good deal! smiles back.