Okay, I'm new to the forum, and also new to VB programming, so this one may be easier than I think. I'll try to explain.

What I have going on is I'm bringing value 'x' into a hidden empty cell in an exsisting sheet (we'll call it cell D9) from another VB.net component outside of Excel. And within the VB.net script I'm also prompting a series of macros to run after 'x' is imported to the sheet. I need value 'x' to be added to an exsisting value 'y' (via VB macro) that is already in the sheet (calling this cell B9). The result from this equation needs to be stored back into the same cell that 'y' is within (B9), because there are about 50 other Dependents that store their values based on that cell. Here's the final piece... value 'y' is a non-calculated number that is a result of solver equations running in the background, and that value changes with each set of data, so my final value 'z' will be dispersed among several other cells within the sheet and will vary based upon the solver calculations. The only constant in my sheet is value 'x' that is imported into the sheet. All other values change automatically with the solver & other macros.

Any help at all is much appreciated.

-Joel