View Single Post
  #3   Report Post  
NlCO
 
Posts: n/a
Default


Thank You Dominic, I tried your solution but it didn't worked, I receive
a message saying:

Ambiguous Name Detected: Recalc

But through that error I finally found the answer:

Worksheets("Sheet1").UsedRange.Range("E30:E56,G30: G56").Calculate

Thanks a lot

Nico :) :)


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=394528