View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default copying cells from one worksheet to several others

Id did work. Thanks a lot

"Jerry" wrote:

I have a worksheet that I want to copy cells a1:a14 unto other several
worksheets. I want these cells to be selected and then inserted into the
other worksheets to the same range. Can not copy them because it replaces
the info and right now I can only select once and then insert special. I
have to copy this info to about 70 other worksheets and I want to automate
it. Can anyone assist me with this task? Thanks in advance.