Hi again
(Previous thread: http://www.excelforum.com/excel-prog...is-opened.html)

Using the code that romperstomper gave, I've put part of my macro in, but the first part is an If function which checks whether a string is present in specific cells.

...
If ActiveCell.Value = "" Then
GoTo Part
Else
End If 
...
Is there any way to stall the macro from running to let the file load properly please?

I've tried a few Application.Waits and Application.Refresh but got nowhere.

Thanks again

Aaron