VBA CODE that REFRESHES ALL WORKSHEETS

[drobinson782001]

I have 6 excel worksheets that are connected to a SQL database. I have a macro that refreshes all worksheets with the correct data from the database. The problem is that when i click on the RUnRefresh macro it gives and error 1004. "Please wait while excel refreshes then rerun again". so when that error comes it always goes to worksheet 6 and i have to be pressing F5 so that it refreshes worksheets 7, 8, 9 and so on until it fininshes . Here is the code below, someone please help

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[AlphaFrog]

Maybe give this a try.

Please Login or Register  to view this content.

[drobinson782001]

Is there anyone who can ASSIST

[drobinson782001]

heeeeeelllllppppppppppppp