Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro question
Scott,
If that, by itself, takes more than an eye-blink, I'd be surprised. Do you have other workbooks open? Or a lot of formulas in a big workbook? Then perhaps you can turn the calc mode to manual before the routine, and reset it after. HTH, Bernie MS Excel MVP "scott23" wrote in message m... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro Question | Excel Discussion (Misc queries) | |||
Macro question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Discussion (Misc queries) |