Mark, Can you add the line of code that is passing the parameter to the OLAP
object.

"Mark" wrote:

I have a Excel 2007 worksheet that makes a connection to a OLAP Cube on a
server.

When I change a cube member, i.e., a parameter, the cube values update
themselves automatically.

When the parameter change is made programatically, the program execution
will NOT wait for the cube values to resolve before moving up to the next
line of code. This is obviously no good when the next line of code is to
print the worksheet.

How can I make the program wait allowing it to update the cube values before
moving on.

Thanks,
Mark