I have 2 ranges I need to loop through. Both are defined name ranges.
aRange is cell a1:a20
cRange is cell c1:c20
both ranges may increase or decrease but will stay the same rows for both
I need to check to see if there is a value in the cRange that is greater or less than 0 and if aRange = "" then
select the aRange cell and exit the sub. If condition is false continue
I have tried multiple ways and none seem to work so figured I would just post what im trying to do. Thanks.
aRange is cell a1:a20
cRange is cell c1:c20
both ranges may increase or decrease but will stay the same rows for both
I need to check to see if there is a value in the cRange that is greater or less than 0 and if aRange = "" then
select the aRange cell and exit the sub. If condition is false continue
I have tried multiple ways and none seem to work so figured I would just post what im trying to do. Thanks.