Good morning Nico

Highlight a portion of your spreadsheet and then run the code below.
This should recalculate only the highlighted section of your sheet.

Sub Recalc()
ActiveWindow.RangeSelection.Calculate
End Sub

HTH

DominicB


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