View Single Post
  #1   Report Post  
Anand
 
Posts: n/a
Default copy-paste as Values automatically

I have a worksheet with an inherent circular calculation. To get the answers
to converge, I need to copy D85:W85 to row 55 as Values and hit shift+F9. I
keep doing this (about 5-6 times) till the numbers in D86:W86 are less than
say 100.

Is there a way to automate this process with either a function or a macro?

Thanks in advance,

Anand