Thread: Macro question in Excel
View Single Post
Old 16-01-2007, 11:32   #4
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Macro question in Excel
The code works fine in Excel 2000 once the next line is removed.

---------- Post added at 10:32 ---------- Previous post was at 10:20 ----------

Macros aren't very efficent.

This performs the same function in half the lines

With Worksheets("ccreport")
.Range("E:F").Cut
.Range("B:C").Insert
.Range("b1:c2").ClearContents
End With
Application.CutCopyMode = False
gazzae is offline   Reply With Quote