Issue: Selects empty cells beyond last data cell

[VPeters]

Hi,

I am trying to do a random sort and pull values from column A. The amount of data in that column will change each time I use this template spreadsheet.

When my loop does the pull it selects a couple of empty cells past the last cell of data. How do I correct that? Is it my iRange? Below is my code:

Please Login or Register  to view this content.

[swoop99]

Psst. Put [ code ] tags around your macro there before a mod comes in and beats you with a stick. We're not actually allowed to answer your question until you're not breaking any of the forum rules.

[VPeters]

Right of Way Flexibilities Project List (2).xlsm

Hi,

I am trying to do a random sort and pull values from column A. The amount of data in that column will change each time I use this template spreadsheet.

When my loop does the pull it selects a couple of empty cells past the last cell of data. How do I correct that? Is it my iRange? Below is my code:

Please Login or Register  to view this content.

[swoop99]

Try changing your 'iRange =' to

Please Login or Register  to view this content.

That will assign the row number of the last cell in the column with any data in it.

[VPeters]

Making that change to the iRange pulls more blank cells than the original iRange