Possible 1-liner

[stanl]

I'm looking to extract vba macro code from 27 workbooks and combine it into a single routine. Basically each month certain values will be imported into an 'Export' tab then distributed amongst other worksheets.

So given existing code like

[VBA]
Sheets("schexport").Select
Range("B12:F12").Select
Selection.Copy
Sheets("toisnot").Select
Range("b36").Select
ActiveSheet.Paste
[/VBA]

can this be condensed into a single line? Stan

[Bob Phillips]

[vba]

Sheets("schexport").Range("B12:F12").Copy Sheets("toisnot").Range("b36")
[/vba]

[stanl]

Uh! I felt so dumb after pressing the enter key... it is that easy. Thanks.