VBA to copy certain columns to all worksheets

Hi I'm looking to create code for copying certain columns (C to AT) from Sheet1 across all worksheets then skipping worksheets named "Sheet1"

I know that I need to use PasteSpecial method, but I'm having troubles with loop.

Worksheets("Sheet1").Range("A2").Copy
Worksheets("Sheet2").Range("A2").PasteSpecial Paste:=xlPasteFormulas

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

As per the code you posted, the above code will paste the value of Cell A2 to all of the other worksheets. You can use a similar approach to paste all/part of a column.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M