Hallo Andy,
first of all thanks for you quick replay....
i have tried your method and if i use simple code as belowe than it is working perfectly
but in my macro it is not helping. My Macro is pretty "Big" takes couple of minutes to created all files we need. and i never used the DoEvents command in my macro (actually, not really understand what does it do).
Also in my Macro I'm getting the information from different location. My Macro runs trhough couple of sheets to get the current information.
Any suggestion where can i search for solution?
Bookmarks