range command doesn't show values when hovering cursor

I have what seems to me to be identical code trying to look at a cell value.

When I'm running my macro in single step debug mode and hover my cursor over this command:

Please Login or Register  to view this content.

It displays the true value in the appropriate row in column "S" ** I is in for/next loop. This code works as intended.

But I have another piece of code in the same for/next loop that doesn't show the value when I hover the cursor and also doesn't work properly:

Please Login or Register  to view this content.

I visually see that the cell value does not = "" but the code skips instructions following the "Then".

Both column S and column D are defined as "General".

Thanks for any assistance.

Hi there,

Neither of the ranges shown in the code you've posted is fully qualified - this means that the range will refer to whichever worksheet happens to be active when each line of code is executed. Is there any code between the two statements which changes the active worksheet?

In general you should use fully-qualified references to avoid potential problems, e.g.:

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.

when you are dealing with more than a single workbook.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg M

Thank you so much for your response. There are 3 worksheets in the workbook, but I only run the macro from one worksheet and I don't change the active sheet anywhere in the macro.

I will try your suggestion though and see if that will solve the issue. I have to leave for the evening but will try it out tomorrow and let you know the results.

Another thing -- I don't have the .Value qualifier at the end of the command as you do in your sample. Wonder if that would make a difference although I don't have it on either of my commands.

Hi Greg M,

I make the change to fully qualify and the hovering over the command still did not work. I then used the not fully qualified command but added the "Value" parameter and that worked for the hovering. Then when I hovered in single step I could see the value. I was checking for value not equal to "" so when I hover it shows "Empty" but does not perform the statements following the "Then" parameter. In other words it goes to the 'End if' statement.

I don't know if it has to do with the format of the cells in column "D" which is set to "General" but this solved my problem - I just fill the cells with a value "x" and change the if statement to check for that value. Thanks for your invaluable help!

I will mark this post solved..

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

You're welcome - glad to hear that everything seems to be working correctly for you now.

Best regards,

Greg M