I have a code that does a vlookup function for all cells
in a range then copies the results and pastes values. The
problem is that it looks like it pastes values before the
vlookups are finished calculating. I have tried the
Application.Wait command to no avail. When I step through
the macro it calculates fine. Is there another way to
force VBA to wait until the worksheet is finished
calculating before proceeding?

Hi Chris,

A bit difficult to say!
What formulas in your worksheet? What data? What code in your module? What
results did you expect? What did you get instead?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Chris" wrote in message
...
I have a code that does a vlookup function for all cells
in a range then copies the results and pastes values. The
problem is that it looks like it pastes values before the
vlookups are finished calculating. I have tried the
Application.Wait command to no avail. When I step through
the macro it calculates fine. Is there another way to
force VBA to wait until the worksheet is finished
calculating before proceeding?

Is your calculation set to Automatic (ToolsOptionsCalculation)? Try
Application.Calculate instead of .Wait also.

"Chris" wrote in message ...
I have a code that does a vlookup function for all cells
in a range then copies the results and pastes values. The
problem is that it looks like it pastes values before the
vlookups are finished calculating. I have tried the
Application.Wait command to no avail. When I step through
the macro it calculates fine. Is there another way to
force VBA to wait until the worksheet is finished
calculating before proceeding?