Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanks to all for yout tips...
...but i've found on my own the solution i was lookin for. just 3 lines of code and a magical word: "Workbooks" this is the macro i wanted to implement Sub copiaform_da_MytyM2_a_MytyM() ' ' copiaform_da_MytyM2_a_MytyM Macro ' Macro registrata il 19/10/2005 da fulvio Dim i As Integer For i = 15 To 123 Step 12 Workbooks("My.T.y.M.xls").Worksheets("saved line-ups").Range("B" & i).Value = Workbooks("My.T.y.M2.xls").Worksheets_("saved line-ups").Range("B" & i).Value Workbooks("My.T.y.M.xls").Worksheets("saved line-ups").Range("C" & i + 1 & ":C" & i + 11).Value = Workbooks_("My.T.y.M2.xls").Worksheets("saved line-ups").Range("C" & i + 1 & ":C" & i + 11).Value Workbooks("My.T.y.M.xls").Worksheets("saved line-ups").Range("E" & i + 1 & ":E" & i + 11).Value = Workbooks_("My.T.y.M2.xls").Worksheets("saved line-ups").Range("E" & i + 1 & ":E" & i + 11).Value Next i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |