Copying data from one cell to another

  • Thread starter Thread starter cakonopka
  • Start date Start date
C

cakonopka

Hi there all

i want to copy info from one cell into another with the click of
button, any idea how i do this?

cheers


from C
 
Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("B9"
End Sub
 
Is it possable to do it so it say copys A1, then clears the contents o
A1, and copies it to say B1, and next time it's run to B2, then B3 an
so on
 
Hello CK,

Here's are two articles help with your question.

MSDN Article: "Chapter 5: Using Ranges"
Link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexvba/htm
l/odc_5709_chap05idx.asp

KB Article: How to Customize a Custom Toolbar Button
Q213754



Sonny Kocak
(e-mail address removed)
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| From: "Tom Ogilvy" <[email protected]>
| References: <[email protected]>
| Subject: Re: Copying data from one cell to another
| Date: Tue, 3 Feb 2004 16:28:51 -0500
| Lines: 27
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.excel.programming
| NNTP-Posting-Host: host-141-116-172-231.ptr.hqda.pentagon.mil
141.116.172.231
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.excel.programming:459000
| X-Tomcat-NG: microsoft.public.excel.programming
|
| Private Sub CommandButton1_Click()
| Range("A1").Copy Destination:=Range("B9"
| End Sub
|
| --
| Regards,
| Tom Ogilvy
|
|
| | > Hi there all
| >
| > i want to copy info from one cell into another with the click of a
| > button, any idea how i do this?
| >
| > cheers
| >
| >
| > from CK
| >
| >
| > ---
| > Message posted
| >
|
|
|
 
Back
Top