refresh

Sub zrefresh()
Sheets(Array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j")).Select
Selection.QueryTable.Refresh BackgroundQuery:=True
End Sub

i want to refresh and import data from web. can i know why is it not working
thank

sungpeng

1) Go back to your original post, select the edit key, highlight the code, then press the # button. This will wrap your code.

2) What is the error message you are getting?


rylo

run-time error '1004':
Application-defined or object-defined error