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

Hi Ramzes,
To understand your question I turned on "Record Macro" and clicked on a pivot table. I got two lines of code:

    ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
    ActiveWorkbook.RefreshAll

I don't see any RefreshSheet word in the Object Model.

My normal method to understand these kinds of questions is to record a macro and then see how I might modify it to work in general.

hope this helps.

Thanks.

It did work. I needed the part with workbook only.
Thanks for your help.

Simon