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
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