help debugging for/next, if/elseif/endif

[bruizer31]

Hi everyone, I am hoping someone can help me out with this, i cant seem to find what i am doing wrong.

This code should be looking in the columns for 0's, chaning the cells to blank. then with cells that arent blank in the columns, it should check to see which ones are not within the specified parameters, and if the cells arent it adds the error message to the end of whatever error message is already in the same row in column 27.
I really appreciate anyones help on this!

Please Login or Register  to view this content.

[Norie]

What do you need help with?

The only problem I can see is the very last End If.

It's not needed as the very last If is all on one line.

[JosephP]

what is happening that shouldn't or not happening that should?

[bruizer31]

it is not replacing the 0's with blanks, and it is skipping everything after waist circ/bmi. Deleting the last end if now, thank you.

[bruizer31]

also, i'm hoping it is clearing the 0's. then comparing to the greater than less than... will it still say cell is out of range if it is comparing a blank cell to <4?

[bruizer31]

actually, skipping everything after weight...

[Norie]

Remove the quotes around 0, unless you are actually looking for the string '0'.

By the way, the code probably isn't skipping anything, it just appears so because nothing is happening.

To check that you can step through it with F8.

[bruizer31]

when stepping through, it is skipping after this line

Please Login or Register  to view this content.

it then picks up on last four social and then is done running

[JosephP]

all the subsequent code is dependent on that test and will only run if both those conditions are true-which also happens to exclude most of the following code if not all

[Norie]

None of the code after that point is executed?

[bruizer31]

correct, i do have values that are wrong, and 0's even though i have removed the quotes, that arent getting deleted.. I would post a example doc but its health info so i cant

[Norie]

Oops, looks like I misread the code.:oops:

I blame lack of indentation.

PS You could post an example workbook with dummy data.

[bruizer31]

thanks joseph, when i move that to the bottom the rest runs, how can i word it so that i dont have that error? running into a meeting so my posts will be delayed for a little while

[JosephP]

perhaps just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[bruizer31]

thanks guys, working now. Appreciate yalls help!

[bruizer31]

one last thing... im getting a type error whenever i try to get a this value. Im trying to make an if statement to compare

Please Login or Register  to view this content.

, and if the difference is greater than one, (positive or negative) it will produce another error in cells (i,27).

What is the best way to do that?
Thanks you guys

[Norie]

Are you trying to round the sum of columns 15,16 and 17 divided by 5?