refresh

[sungpeng]

Sub zrefresh()
Sheets Array("a", "b", "c", "d").Select
Selection.QueryTable.Refresh BackgroundQuery:=True
End Sub

can i know what wrong with my code

[rylo]

sungpeng

1) Can you please edit your post to wrap your code as per the forum rules.

2) Not sure about the query part but change

Sheets Array("a", "b", "c", "d").Select

to

Sheets(Array("a", "b", "c", "d")).Select

for the grouping.


rylo

[mudraker]

sungpeng

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[sungpeng]

how to edit my post to wrap my code

[sungpeng]

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

[rylo]

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

[sungpeng]

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