Is there a easier way of refreshing formula data of a macro in a
column. I can do this manually, but does take a great length of time in
doing so. Is there a VB code of doing this macro, which would make life
easier.

many thanks

What do you mean by refreshing formula data. Do you mean generate a
calculate? If so, VB doesn't really affect how long it takes to calculate a
sheet. That is more a design issue and the formulas you are using. Perhaps
a clearer statement of the problem would be beneficial.

--
Regards,
Tom Ogilvy


" wrote:

Is there a easier way of refreshing formula data of a macro in a
column. I can do this manually, but does take a great length of time in
doing so. Is there a VB code of doing this macro, which would make life
easier.

many thanks

I have two formulas that need to be updated. One is a worksheet change
method that updated colours of a cell and a MAX function that would
retrieved the highest value from another cell. So I am looking for help
on implementing a VB module code of a macro that would refresh or
update these formulas.

Regards

Imran



Tom Ogilvy wrote:
What do you mean by refreshing formula data. Do you mean generate a
calculate? If so, VB doesn't really affect how long it takes to calculate a
sheet. That is more a design issue and the formulas you are using. Perhaps
a clearer statement of the problem would be beneficial.

--
Regards,
Tom Ogilvy


" wrote:

Is there a easier way of refreshing formula data of a macro in a
column. I can do this manually, but does take a great length of time in
doing so. Is there a VB code of doing this macro, which would make life
easier.

many thanks

The change event is fired when a cell is edited or received input via DDE.
So you code would need to edit a cell that will cause your change event to
perform the desired action.

A formula is updated by a calculation. You can do

Application.Calculate

to force a calculation.

--
Regards,
Tom Ogilvy


" wrote:

I have two formulas that need to be updated. One is a worksheet change
method that updated colours of a cell and a MAX function that would
retrieved the highest value from another cell. So I am looking for help
on implementing a VB module code of a macro that would refresh or
update these formulas.

Regards

Imran



Tom Ogilvy wrote:
What do you mean by refreshing formula data. Do you mean generate a
calculate? If so, VB doesn't really affect how long it takes to calculate a
sheet. That is more a design issue and the formulas you are using. Perhaps
a clearer statement of the problem would be beneficial.

--
Regards,
Tom Ogilvy


" wrote:

Is there a easier way of refreshing formula data of a macro in a
column. I can do this manually, but does take a great length of time in
doing so. Is there a VB code of doing this macro, which would make life
easier.

many thanks