find a range of empty cells within a range of cells

[COURTTROOPER]

Hi all. I need help trying to modify some code I am using to limit a range of cells being sorted to exclude the empty cells in the range being sorted. The range being sorted is AG5:AG16 but during the sort it puts counted data in cells that are blank. I am not sure why this is happening but I think if I can limit the sort to only the cells that have an ID number in them that should fix it. I don't know how to get this code to only put data into the cells that have the ID numbers in them as the number of people working on a given day changes. I list them by their ID number in range of AG5:AG16 but there are only 3 permanent listed in cells AG5:AG7 and the rest are entered as needed up AG16. I know how to find the number of rows used for the sheet but not sure how to find the number of empty cells within a range of AG5:AG16. All help is greatly appreciated!

Here is the code I am using now.

Please Login or Register  to view this content.

[JLGWhiz]

I think this is what you want

Please Login or Register  to view this content.

[COURTTROOPER]

Boy do I feel dumb right now! Thanks so much I had it in my head that I needed another set of code to do that!!
KISS "Keep It Simple Stupid"
Thanks so much works fine!

[JLGWhiz]

Boy do I feel dumb right now! Thanks so much I had it in my head that I needed another set of code to do that!!
KISS "Keep It Simple Stupid"
Thanks so much works fine!

You're welcome,
regards, JLG