xld, the code below, it gave me a compile error "Method or data member not found.
[VBA]
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
sh.RefreshAll
Next sh
[/VBA]
xld, the code below, it gave me a compile error "Method or data member not found.
[VBA]
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Worksheets
sh.RefreshAll
Next sh
[/VBA]
Sorry mate, that was clumsy. It is even easier than that
[vba]
ActiveWorkbook.RefreshAll
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
perfect, thanks, that worked.