[Excel] Macro Mixing Relative and Fixed References

[tcss]

Hi again everyone,

Sorry to have so many questions!

I'm trying to create my first macro but I need it to have both relative and fixed references. Basically what I need is:

1. Copy value from a location that moves down a list one item at a time.
2. Paste this value into the same cell every time.
3. Copy a second value from a different location that never changes.
4. Paste this second value into a location that moves down a list one item at a time.

I made a diagram that sort of shows what I mean...




So to accomplish this I tried creating two macros, one that was with fixed references and one with relative references, and splicing them together to get the following:

Sub Copy1()
'
' Copy1 Macro
'

'
ActiveCell.Offset(-4, -1).Range("A1").Select
Selection.Copy
Range("C2").Select
ActiveSheet.Paste
Range("H20:I20").Select
Application.CutCopyMode = False
Selection.Copy
ActiveCell.Offset(-18, 3).Range("A1:B1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub


But not surprisingly I got an error: "Run-time error '1004': Application-defined or object-defined error." When I click debug, it highlights the line ActiveCell.Offset(-4, -1).Range("A1").Select in yellow.

Can anyone help? I would appreciate it very much.

Thank you!