Thread: worksheet calculate - how to run it line by line?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default 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



Reply With QuoteReply With Quote