View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
fra fra is offline
external usenet poster
 
Posts: 4
Default looping through ranges: how to speed up?

On Sat, 26 Jun 2004 00:07:45 -0700, Alan Beban wrote:

I guess the testing should be done before the posting. The line below
should be

unique_cod.Add Elem, CStr(Elem) rather than unique_cod.Add Elem, CStr(x)

Sorry,


no problem... and YES it is a boost! the calc time needed was a
"coffee+smoking break" and now is a "check this ng break" :-)

I think this info should be highlight somehow in the manual.

Alan Beban


thank you very much

Ciao
FF