Thread: Insert Code
View Single Post
  #1   Report Post  
Derek Y via OfficeKB.com
 
Posts: n/a
Default Insert Code

I have some VBA code that I would like to insert into an excel worksheet

With ActiveCell.Columns
.EntireColumn.Copy
.EntireColumn.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

End With
Application.CutCopyMode = False

I thought all I would have to do is create a macro, use the macro editor and
paste in this code instead and run that macro, and this code would run
instead.....Thats not working.......how do i run this code??


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200510/1