Excel update too slow for VBA 1

[maxpi]

Hi all

I have some VBA code that gets an array from the web and puts it into Excel. Then I have some functions on that page in Excel and I want VBA to copy the results of the functions to another page in Excel. I have to run the routine twice because the first time the VBA does not
wait for the calculation to take place before it copies and pastes the result to another sheet. I tried putting an "Application.calculate" statement in there but it does not help.

I also tried writing a line of code like this to do the
calculations in VBA but the VBA editor is
marking it red and I can't figure out how to write it
correctly: "Value1 = WorksheetFunction.Large(E1:E60,2)"

I do have the Excel setting to update automatically.

Max

 

[SkipVought]

Hi,

Not knowing hardly ANYTHING about your application (which could be VERY significant) except what you have posted...

let me ask a stupid question.

Why do you want the same data on separate sheets? Skip,
metzgsk@voughtaircraft.com

 

[euskadi]

Try this:

Value1 = Application.WorksheetFunction.Large(ActiveSheet.Range("E1:E60"), 2)