Posted to microsoft.public.excel.programming

external usenet poster

Posts: 34

cpu saving..

hi evrybody !! can anybody make this code more economic for my cpu?? (it is
not a big problem, but maybe there is something better)
ty..!! this is part of code of a macro called every 2 seconds..

aWS.Range("H7").Value = aWS.Range("H1").Value
aWS.Range("H7").Copy
aWS.Range("A1").Insert Shift:=xlDown
aWS.Range("H7").Copy
aWS.Range("A1").Insert Shift:=xlDown

aWS.Range("A801").Delete Shift:=xlUp

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
Saving as XML	Gavin Bird	Excel Discussion (Misc queries)	0	August 15th 11 04:20 AM
Automaticly saving formula's to values when saving	Gunti	Excel Discussion (Misc queries)	8	November 11th 08 09:34 AM
Saving a spreadsheet without saving the Macro	tedd13	Excel Programming	7	March 31st 06 02:17 PM
Saving a Workbook: Forcing User to Rename before Saving	Rollin_Again[_6_]	Excel Programming	5	April 16th 04 02:54 PM
Saving Changes	abxy[_51_]	Excel Programming	2	April 12th 04 10:37 PM

All times are GMT +1. The time now is 05:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us