Solved: VBA for updating every worksheet in workbook.

[Aussiebear]

[vba]Dim wb As Workbook
For each wb in Application.Workbooks
'do updating here
Next[/vba] will cycle through all open workbooks

Try this instead
[VBA]
Dim sh As Worksheet
For each sh in Workbook
'do updateing here
Next
[/VBA]