Posted to microsoft.public.excel.programming

scott23

external usenet poster

Posts: 15

macro question

Is there a way to rewrite this so that it doesnt take so much memory
and processing time to work ?

Sub scalp_line1_button_click()
Range("b3:m3").Copy
Sheets("CLOSED").Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).PasteSpecial Paste:=xlPasteValues
Range("b3:d3").ClearContents
Range("f3:h3").ClearContents
Range("j3:k3").ClearContents
Range("m3:m3").ClearContents

End Sub '

Thanks
scott

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
Excel 2007 Macro/VB Question DDE Question	MadDog22	Excel Worksheet Functions	1	March 10th 10 01:47 AM
Macro Question	ddbro	Excel Discussion (Misc queries)	4	August 1st 08 08:26 PM
Macro question	Jim G	Excel Discussion (Misc queries)	0	January 25th 08 12:48 AM
Macro Question	Vick	Excel Discussion (Misc queries)	1	November 27th 07 02:58 PM
Macro Question	Vick	Excel Discussion (Misc queries)	1	November 21st 07 06:28 PM

All times are GMT +1. The time now is 08:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us