Do Until Loop - not going into correct if statement?

[sweedey]

I have a pretty simple code that should just be rearranging some data into the proper format and then determining whether the data in a column is negative and if so highlighting it red (I know i can do this with conditional formatting, but in this case I need to use a macro). Everything works perfectly until it gets to the second loop - then whether it is negative or not, when I step into the code it goes through the positive if statement.

Please Login or Register  to view this content.

Can anyone help?

Thanks!

[TMS]

You're checking and "incrementing" the ActiveCell but you're operating on the range "rng".

Regards

[sweedey]

Thanks - I'm not sure I completely understand why it wasn't working - but I replaced all the rng 's with ActiveCells and it works now!~

Erin