PDA

View Full Version : Refresh Worksheet



prakharc
05-05-2011, 08:11 PM
How can I refresh worksheet through excel macro.

Worksheet.Calculate isn't working

And I can't use Application.Calculatefull as I don't want to refresh whole workbook

mancubus
05-05-2011, 10:34 PM
from vba help:

Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table.

Syntax
expression.Calculate
expression A variable that represents a Worksheet object.

Remarks
All open workbooks:
Application.Calculate
(or just Calculate)

A specific worksheet:
Worksheets(1).Calculate
A specified range:
Worksheets(1).Rows(2).Calculate

Example
This example calculates the formulas in columns A, B, and C in the used range on Sheet1.

Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate