Posted to microsoft.public.excel.programming

Gijs Breedveld Gijs Breedveld is offline

external usenet poster

Posts: 13

Slow VBA code?

I have code which clears a table which was generated the previous run. The
code is:

Range("b20000:o20000").Select
Selection.AutoFill Destination:=Range("b10:o20000"), Type:=xlFillDefault
Range("b10:o20000").Select

I just want to clear the contents and the formats of the previous table
before I build up the next table.

Is there code which can do this faster? It is very slow. Takes about 60
seconds.

Best regards, Gijs

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
Slow code when used as VBA code instead of macro (copying visible columns)	[email protected]	Excel Programming	3	April 2nd 07 05:26 PM
slow code	NickHK	Excel Programming	0	December 21st 06 02:32 AM
Can someone help me with this slow code	BillReese	Excel Programming	7	September 3rd 05 12:34 AM
Slow Code	Frank Kabel	Excel Programming	1	July 23rd 04 09:28 AM
Is this slow code?	Tom	Excel Programming	4	March 3rd 04 11:18 PM

All times are GMT +1. The time now is 06:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us