Run time error 57121

It would probably help if you linked to the previous post, or better yet, if this is a continuation of the same problem, don't start a new thread.

As is, its hard to tell what you're talking about.



I should add that putting a "delay" between when you open the workbook and when the VBA starts, is kind of contradictory, you would need to employ VBA to accomplish such a delay, as far as I know.

the post I am referring to is the following from someone else and not one that I have posted.

http://www.mrexcel.com/board2/viewtopic.php?t=25518&highlight=bizarre

He refers to a "wait", do you know what it means?

Thanks

Ash

Ah jeez!

A Mr Excel/Mark O'Brien post, I might get myself in trouble.

Apperantly, MrExcel was having a problem because the spreadhsheet wasn't completely loaded before a VBA reference to a sheet was made, thus bugging up the reference. Keep in mind, that VBA was already running at this point.

Code as follows:
will pause your code.

You don't need the If, but wait returns the boolean value True once the end time is reached, so that's where you'd put your code that need to fire once the wait time is expired.

To my knowledge, there is no way to cause Excel to pause before beginning the execution of VBA code, since as I said, this would require code to accomplish.

HTH,

Thanks very much. That works and I don't know why!!!!

ASHLAD