Repeat Macro

[posfog]

Hi All,
Been looking all over the place and cant find an answer to the following

I have this simple macro and want it just to repeat constantly with it never stopping

Sub refresh()
'
' refresh Macro
'


'
Calculate
End Sub


So wondered if someone could assist at all please???

 

[jasonb75]

repeat constantly with it never stopping

I supsect that your request might be more literal than you intended, but this is what you have asked for

Sub refresh()
'
' refresh Macro
'


'
Do
Calculate
Loop
End Sub

 

[posfog]

I supsect that your request might be more literal than you intended, but this is what you have asked for

Sub refresh()
'
' refresh Macro
'


'
Do
Calculate
Loop
End Sub

thanks Jason this refreshes the one formula but the VLOOKUP formulas stay as they are?

Any idea?

 

[offthelip]

It might help if you explain a bit more about what you are trying to do, because it should not be necessary to continually recalculate all the time. If you are trying to solve a problem by doing that it is probably the wrong approach

 

[jasonb75]

A formula result will only change when a precedent value changes. If a precedent value has changed and the formula is not updating as expected, then it could be that you're using the wrong type of formula or possibly that the formula doesn't work in the way that you think it will. Without more information from you diagnosing the problem is near impossible.

If you have automatic calculation on then you shouldn't need a macro to refresh constantly.