Put a command button on the sheet and double click on it.

You will see much the same.

--
Regards,
Tom Ogilvy

Stormin' German wrote in message
...
Tom,

would you please expalin the first row of your
reply...what is Private Sub, etc.?


-----Original Message-----
Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("B9"
Range("A1").ClearContents
End Sub


--
Regards,
Tom Ogilvy

"cakonopka "
wrote in message
...
Hi there all

a problary most simple thing for you, im looking for a
macro where ti
will move the data from one cell to another when i
click it, thats it,
i know there is problary some simple thing but i dont
know it, lol.

if u cant do it please let me know so i can stop
trying, lol

cheers

from ck


---
Message posted from http://www.ExcelForum.com/



.