chungtinhlak
01-09-2009, 07:55 AM
xld, the code below, it gave me a compile error "Method or data member not found.
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
sh.RefreshAll
Next sh
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
sh.RefreshAll
Next sh