worksheet calculate - how to run it line by line?
 

hi all

I have a Worksheet calculate that I need to run line by line (there i
an error somewhere). how can i do it?

Many thanks

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=38460

worksheet calculate - how to run it line by line?
 

Hi Bondcrash,


With calculation set to manual, try:

Sub Tester()
Dim i As Long

For i = 1 To ActiveSheet.UsedRange.Rows.Count
Rows(i).Cells.Calculate
Next

End Sub

---
Regards,
Norman



"bondcrash" wrote
in message ...

hi all

I have a Worksheet calculate that I need to run line by line (there is
an error somewhere). how can i do it?

Many thanks

BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=384600

worksheet calculate - how to run it line by line?
 

cheers Norma

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=38460