Need to move specific data from sheet 1 to sheet 2

[garyclark21]

I need to move data from Sheet 1 (B18 to I 26) to Sheet 2

The data needs to be placed on Sheet 2 beginning at row 40

I need to then hide columns F and G.

A sample file is attached.

Any help is appreciated !

[stnkynts]

Please Login or Register  to view this content.

[garyclark21]

Thanks .. how would I paste it as a linked image in lieu of values. I would like to maintain column width integrity.

[stnkynts]

For future reference; You can done all this through the "Record Macro" feature in excel.

Please Login or Register  to view this content.

[garyclark21]

This provides a range class error ...

ws2.Range("B40").Select

[stnkynts]

I do not receive an error.

[garyclark21]

I appreciate the help. Attached is the file with the code. Hit the Command 3 button on the first sheet to execute.

Still getting the error.