Why are IFs not working?

[ritz]

Hi,
I posted yesterday having a problem with several ifs in a sub that are not all executing. per a suggestion I went ahead and changed the locations of my end ifs. Now the only one that is executing is the first one in the sub.
here it is:
Any help is appreciated
Thanks,
Ritz

Please Login or Register  to view this content.

[davesexcel]

I belive you need to say
if activecell.offset(0, 16) > activecell.Offset(0, 15) Then

[antoka05]

When you have 'If' on more lines you need to use 'End If' instruction:

Please Login or Register  to view this content.

Regards,
Antonio

[jasoncw]

The 3 End If statements at the end were misplaced. Try this:

Please Login or Register  to view this content.

Jason

[ritz]

Thanks guys.
putting the end ifs in the right places definitely worked.
-ritz