View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mas[_4_] Mas[_4_] is offline
external usenet poster
 
Posts: 4
Default How to copy a range of cells and paste into a new workbook in differentcolumns

Hi all,

I have created a macro that copies and a number of columns and pastes
them in a new workbook in a variety of columns but the macro look
unprofessional as it flickers between copying column A and paste in
column A of the new workbook, copy column C and paste in column B, etc.

I would like to copy a range i.e. column A, C, D, F, G in the open
workbook and paste in a new workbook in columns A, B, F, G, H. without
all the flicker between workbooks etc.

Appreciate any help I can get.