Recalculating a sheet

  • Thread starter Thread starter Ed Peters
  • Start date Start date
E

Ed Peters

I have a macro I wrote that does a calculation based on a range of cells.
HCP(c6:u6).
I have another macro (procedure) that's executed when a button is pressed.

I want my procedure to ensure every HCP() function is executed in the
workbook before it continues. Any ideas on how I program this into my VB
code?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

force recalculation of function 5
How to control recalculation in VBA? 1
Recalculation Failure 1
Workaround for Excel 2002/2003 UDFs recalculating and changing cel 9
Selective Recalculate 2
Re: Reference must be to a macro sheet? 0
empty arguments recalculation 2
Preventing Recalculate on open 2

Back
Top