Excel 2000 Macro

I am having a problem trying to create a macro that moves one column to the right after entering data, using the R1C1 notation relative cell addressing. I can create a macro that uses absolute cell referencing. If the macro is created in A1 throughD1, for example, and when I use it in, for example, in A11, it will put the first part of the macro in cell A11 then jump to B1 and then complete the reminder of the macro in the first row. Can anyone help me with the relative cell usage so I can use the macro at different locations within a worksheet. Thanks!!!!!!!!