G
Ginola
Hi, I have tried to write few lines codes to cut and paste the active
sheet code to offset ( 2, 1 ). However, when I record the macro, it
use the static value "D6". However can I change this code so that it
can be dynamic ?
hope you understand my poor english
thanks
Selection.Cut
Range("D6").Select
ActiveSheet.Paste
sheet code to offset ( 2, 1 ). However, when I record the macro, it
use the static value "D6". However can I change this code so that it
can be dynamic ?
hope you understand my poor english
thanks
Selection.Cut
Range("D6").Select
ActiveSheet.Paste