Second Loop not picking up

[mattress58]

In the macro below it works great the through the first loop of:

and works the first loop of:

When it loops back around and gets to the

It is reading "0" still instead of the new value that was put in cell T97

How can I fix that issue. I have almost completed this macro and this is the last hold up. Thanks for help.

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Norie]

Are you sure CarADLoc refers to T97?

You set it to reference P97 here and I can't find anything in the code that would change it to reference T97.

Please Login or Register  to view this content.

[Arkadi]

I noticed the same thing as Norie... was "T97" just a typo on the post? or is that the problem?