Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Abay
 
Posts: n/a
Default Macro Excel 97

I am pretty much a newbie at Excel and would like to create a Macro for the
following: (know how to create and edit macros etc.)

Take the value from a cell in worksheet A and paste it into the current cell
(where the mouse pointer is when the macro is executed) in worksheet B .. am
at a loss at how to tell the macro to paste into the current cell ......
apologies if this is a really stupid question ..

Any help would be much appreciated.
..

Abay





  #2   Report Post  
Alan
 
Posts: n/a
Default

Try

Sheet1.Range("A1").Copy
Sheet2.Select
ActiveCell.PasteSpecial xlPasteAll

Regards,
Alan.
"Abay" wrote in message
...
I am pretty much a newbie at Excel and would like to create a Macro for the
following: (know how to create and edit macros etc.)

Take the value from a cell in worksheet A and paste it into the current
cell
(where the mouse pointer is when the macro is executed) in worksheet B ..
am
at a loss at how to tell the macro to paste into the current cell ......
apologies if this is a really stupid question ..

Any help would be much appreciated.
.

Abay







  #3   Report Post  
Abay
 
Posts: n/a
Default

I will give it a try .. many thanks.

abay

"Alan" wrote in message
...
Try

Sheet1.Range("A1").Copy
Sheet2.Select
ActiveCell.PasteSpecial xlPasteAll

Regards,
Alan.
"Abay" wrote in message
...
I am pretty much a newbie at Excel and would like to create a Macro for

the
following: (know how to create and edit macros etc.)

Take the value from a cell in worksheet A and paste it into the current
cell
(where the mouse pointer is when the macro is executed) in worksheet B

...
am
at a loss at how to tell the macro to paste into the current cell ......
apologies if this is a really stupid question ..

Any help would be much appreciated.
.

Abay









  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Abay

Without the selecting part..........

Sub copy()
Sheets("Sheet1").Range("A1").copy _
Destination:=ActiveCell
End Sub

OR if want value only........

Sub copy2()
ActiveCell.Value = Sheets("Sheet1").Range("A1").Value
End Sub


Gord Dibben Excel MVP

On Sun, 3 Jul 2005 12:15:06 -0700, "Abay" wrote:

I am pretty much a newbie at Excel and would like to create a Macro for the
following: (know how to create and edit macros etc.)

Take the value from a cell in worksheet A and paste it into the current cell
(where the mouse pointer is when the macro is executed) in worksheet B .. am
at a loss at how to tell the macro to paste into the current cell ......
apologies if this is a really stupid question ..

Any help would be much appreciated.
.

Abay





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't find macro in an Excel file to delete it Ron Excel Discussion (Misc queries) 3 July 1st 05 01:07 PM
Saving Excel using Macro mrbalaje Excel Discussion (Misc queries) 4 April 20th 05 02:32 PM
How can I edit cell contents with a macro in Excel? Mind the gaps! Excel Discussion (Misc queries) 2 March 23rd 05 09:51 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 1 March 19th 05 07:43 PM
Open Access Database under and Excel window using a Macro BMSpell Excel Worksheet Functions 1 January 8th 05 06:32 PM


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"