Macro Problem ActiveCell

[ajbojey]

I need HELP!
Here is the macro that I am trying to expand to 200 rows, each row has to work independent of each other with the same macro.
What I want to do is to be able to select any cell in 1st columb from which to run this macro for that row as the rows have to be done one at a time. How do I redefine the Range command to accept just the active cell for the row that I am in?
Here is the first row which works fine.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/18/2002 by Alex Bojey
'
' Keyboard Shortcut: Ctrl+z
'
Range("E2:M2").Select
Selection.Copy
Range("D2").Select
ActiveSheet.Paste
Range("M2").Select
Selection.ClearContents
End Sub

 

[ajbojey]

Hi Dragracer,

Well you did the job, works like a charm. This is going to save me a pile of work.
Sure is good to have good sharp guys around like you. Thank you very much.
Alex

 

[ajbojey]

Hi Dragracer,
Well you did the Job, it is working like a charm, this is going to save me a lot of manual work. It is very good to have sharp guys around like you. If I need anything else, I know who to contact. Thank you very much.
Alex

 

[ajbojey]

Dragracer,
Thank you for your sound advise. The macro is now working like a charm.
Keep up the good work.
Alex