Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3,101

Is there a faster way to loop thru cells

Where lastRow maybe +/- 25000
For i = 5 To lastRow
xlApp.Cells(i, "G").value = _
(xlApp.Cells(i, "E").value - xlApp.Cells(i, "D").value) _
* xlApp.Cells(i, "F").value
Next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?	Will[_13_]	Excel Programming	3	November 6th 07 07:34 PM
For Next loop faster with counter after Next?	RB Smissaert	Excel Programming	22	August 28th 06 05:12 AM
Faster way to loop through two ranges	YH	Excel Programming	5	August 26th 06 05:17 PM
Is there a faster loop than this	Andibevan	Excel Programming	4	August 25th 06 03:27 PM
Faster For-Next Loop?	[email protected]	Excel Programming	3	January 7th 05 09:08 PM

All times are GMT +1. The time now is 08:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us