macro to refresh a sheet

Hello Guys,

I have been trying to write a macro that will refresh the sheet in my workbook which has values called in by formulas from other files. Between Sub and End Sub I have put

Sheets("sheetname").RefreshSheet

Exactly as it is with Pivot tables (but we add ').PivotTable("name").Refr'

It comes back as Error 438 - Object doesn't support this property or method.

If anyone knows where the mistake is please help or maybe I should use some other command for refreshing those formulas.

Also does anyone know a book or maybe a website with macro language - commands.

Thanks for giving it a try.

Simon