part of VB not working after query moved to different sheet

Now that the query has been moved to sheet panel I can not get the calculations to work, so far I have tried: The section in bold works but the rest doesn't. Thank you .

Please Login or Register  to view this content.

When I step through the code Res comes up as empty when it used to have a value. Thanks.

Try this:

Please Login or Register  to view this content.

Thanks

I made the changes and the calculations do not work and stepping through Res is "Empty". Thank you .

Below is the full code, using this Res is "Empty"... I think that is part of the problem but I'm not sure. Thank you .

Please Login or Register  to view this content.