View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default I need a macro that copies that data from one cell on one sheet to a cell on another?

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/