| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| How do I use equation of a line to calculate x-values from known . | Excel Discussion (Misc queries) | |||
| How do I calculate the Root Mean Square (RMS) of line of equality | Excel Discussion (Misc queries) | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
| Macro problem on, Yellowed line - previous line or next line. | Excel Programming | |||
Linear Mode
