Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
Saving Excel using Macro | Excel Discussion (Misc queries) | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions |