Just a guess: you recorded your cut and paste macro. This is an
excellent way to learn how to write macros! If you review the code,
you'll see that it references the cells you used when recording the
macro. The trick now is to alter the recorded code to make it do what
you need it to do.

As an example the macro refers to cell A1 as R[1]C[1] . You can change
this to
Range("a1").select
If you need the column reference to stay static but change for the
current row, change to code to
Range("a" & selection.row).select

Post your code, and indicate what you need the macro to do.