Posted to microsoft.public.excel.programming

Fingerjob

external usenet poster

Posts: 26

Do you manage to make this macro faster??

This marco take over 1 min to run for me....
Does anybody have clue if i can get the run time down.

Br

Petter

Sheets("Sheet2").Select
For i = 0 To 92
rownr = 105 - i
Fjern = Cells(rownr, 6).Value
If Fjern = "Order backlog" Or Fjern = "Orders received" Then
Else: Range("e" & rownr & ",g" & rownr & ",k" & rownr & ":m" &
rownr).ClearContents
End If
Next i

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
How can make Save faster	clara	Excel Programming	0	March 21st 07 08:17 PM
can you make this faster?	John	Excel Programming	2	October 25th 05 08:20 PM
How Can I make excel go faster	Jason Zischke	Excel Programming	8	March 23rd 05 03:55 PM
make my vba/excel program faster	Frank Kabel	Excel Programming	0	May 18th 04 04:58 PM
make my VBA program faster	Neil[_14_]	Excel Programming	2	May 18th 04 04:15 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us