Copying data from one cell to another
 

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

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

Copying data from one cell to another
 

Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("B9"
End Sub

--
Regards,
Tom Ogilvy


"cakonopka " wrote in message
...
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 from http://www.ExcelForum.com/

Copying data from one cell to another
 

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

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

Copying data from one cell to another
 

Hello CK,

Here's are two articles help with your question.

MSDN Article: "Chapter 5: Using Ranges"
Link:
http://msdn.microsoft.com/library/de...us/dnexvba/htm
l/odc_5709_chap05idx.asp

KB Article: How to Customize a Custom Toolbar Button
Q213754



Sonny Kocak

Microsoft Developer Support

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




--------------------
| From: "Tom Ogilvy"
| References:
| Subject: 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:
| 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!TK2MSFTN GXA05.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
|
|
| "cakonopka " wrote in message
| ...
| 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 from http://www.ExcelForum.com/
|
|
|
|