Excel VBA Copy and Paste Range

Hi
May be?
Change to

Please Login or Register  to view this content.

Hi,

All the code below is included in Module6 of the attached copy of your modified Sample Workbook.

You can use 'PasteSpecial' to multiply everything in a range:

Please Login or Register  to view this content.

You did a nice job modifying code you got from the Macro recorder. The code can be made to run faster, by eliminating the 'Select' lines, and replacing 'Paste' with direct copy, especially since most of the time you are Pasting all 100,000+ lines in the Worksheet:

Please Login or Register  to view this content.

The above code works fine, but is not very maintainable (i.e. easy to make a mistake when modifying). The following code is a little easier to maintain:

Please Login or Register  to view this content.

Lewis