stanl
07-25-2007, 05:39 AM
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
Sheets("schexport").Select
Range("B12:F12").Select
Selection.Copy
Sheets("toisnot").Select
Range("b36").Select
ActiveSheet.Paste
can this be condensed into a single line? Stan
So given existing code like
Sheets("schexport").Select
Range("B12:F12").Select
Selection.Copy
Sheets("toisnot").Select
Range("b36").Select
ActiveSheet.Paste
can this be condensed into a single line? Stan