It's quite large ... probably at least 1000

"Gary''s Student" wrote:

Create a small event macro and see if it gets tripped. What is the range of
cells that get refreshed??
--
Gary''s Student - gsnu200804


"Mark" wrote:

How can I tell? (It's late in the day?)


"Gary''s Student" wrote:

Does the refresh trigger a worksheet change event? If the answer is yes,
then the routine could simply exit and rely on the Change Event to do the
printing.
--
Gary''s Student - gsnu200804


"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