VBA Loop to check range for Negative number

Hello Everyone,

I have a fairly simple macro that takes a range of numbers and copies them into another workbook for processing. However, I would like to build in a loop to check the range for any negative values and then stop the macro if one is encountered.

If someone has an idea how to do this either using a loop, or another function, I would appreciate it. The current copy/paste code is below:

Please Login or Register  to view this content.

I just need some sort of check on the data in H5:H100 to ensure the values are all positive, and if not, the macro should halt and give an error message to inform the user to verify the data in the range and make corrections before proceeding.

Thanks for any assistance!
Zarley

Does the data to be processed always fill up exactly H5:H100? If so you could do something like this:

Please Login or Register  to view this content.