Streamline macro code.
 

Hi all. I have a quick question on macro code. When you
record a macro using the record button you get alot of
extra code not needed to preform your macro properly. (I.e
when you copy and paste special only the values of the
cell into another cell, you get alot of funtions that are
false and you can delete that part of the code to save
space and resources in you spreadsheet.) I was hoping some
knew of a site that I could check out to help me steamline
my codes to take up less space and time to run.

Thanks for any help
Pete

Streamline macro code.
 

One of the best things you can do is remove SELECTIONS.
range("a1").select
selection.copy
range("a2").select
selection.paste
can be
range("a1").copy range("a2")

--
Don Guillett
SalesAid Software

"Pete" wrote in message
...
Hi all. I have a quick question on macro code. When you
record a macro using the record button you get alot of
extra code not needed to preform your macro properly. (I.e
when you copy and paste special only the values of the
cell into another cell, you get alot of funtions that are
false and you can delete that part of the code to save
space and resources in you spreadsheet.) I was hoping some
knew of a site that I could check out to help me steamline
my codes to take up less space and time to run.

Thanks for any help
Pete