[ATTACH]n1202926[/ATTACH] I was sent this workbook. When the macro is run the cells on "Sheet1" are copied and pasted to various cells on sheet "Letter". Sheet "Map" has a table that specifies the from and to for each cell. It works great BUT, I can't understand HOW! The code identifies the From and To sheets, but I see no reference whatsoever to the sheet "Map" or it's table. Is something missing here, or I just don't understand what's going on? The code:
Code
Sub CopyStuff()
Dim shF As Worksheet ' From Sheet
Dim shT As Worksheet ' To Sheet
Dim cl As Range ' Cell Pointer
' Initalize variables
Set shF = Sheets("Sheet1")
Set shT = Sheets("Letter")
' Copy from range to range
For Each cl In Range("From_Sheet")
shF.Range(cl.Value).Copy shT.Range(cl.Offset(0, 1).Value)
Next cl
End Sub
Display More