Copy cells automatically in MS excel

Solved/Closed
mahadevan1971 - 11 Jun 2009 à 06:50
 mahadevan1971 - 11 Jun 2009 à 09:03
Hello,
I have an excel sheet full of data .Typically 10 or more cells in a row. I want to copy contents of each cell by simply moving the arrow key over each cell.can you suggest a simple solution for this requirement?

4 responses

mahadevan1971
11 Jun 2009 à 08:31
Hello sir
I want to copy contents of each cell by simply moving the arrow key over each cell.
I need a workable macro or a tool for this task
zaho14 Posts 14 Registration date Sunday 4 January 2009 Status Member Last seen 16 June 2009 11
11 Jun 2009 à 08:22
hye,

To do this you will have to drag and select the contents.... copy and paste where you want!
alex537 Posts 10 Registration date Sunday 4 January 2009 Status Member Last seen 15 June 2009 1
11 Jun 2009 à 08:28
This is the only way to do it!
mahadevan1971
11 Jun 2009 à 09:03
Hai

I tried this code in excel macro :
Sub Copy()
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Copy
End Sub

But it says that "Expecting End Sub"

The code is not working

Please tell me a way to solve this problem

Regards
M S Mahadevan