Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write a simple copy-paste macro?
I've used 123 for over 20 years - simple, easy to learn and use, but my XP
OS doesn't handle it well, so I'm trying to move to Excel. But in Excel I can't even write a simple macro such as: Copy from a cell, move down one space, Paste. It will do this once, but then not continue. If I run it from another cell - just restarts from the original cell. Without further comment, I learned this macro in 2 minutes on 123. I've been working with Excel for a week now, and I'd appreciate some help. To recap, I simply want to be able to choose a cell having data, run a Copy macro and have it paste to the cell below- why is this so damn hard? . Thanks for any help. RHR |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write a simple copy-paste macro?
RHR
Can be frustrating learning a new tool (Just be assured that Excel doesn't get to number one without being better and more flexible, particularly as 1-2-3 ruled the world once) Sub CopyAndPaste ActiveCell.Copy Destination:=ActiveCell.Offset(1,0) End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "R. H. Rosenberg" wrote in message ... I've used 123 for over 20 years - simple, easy to learn and use, but my XP OS doesn't handle it well, so I'm trying to move to Excel. But in Excel I can't even write a simple macro such as: Copy from a cell, move down one space, Paste. It will do this once, but then not continue. If I run it from another cell - just restarts from the original cell. Without further comment, I learned this macro in 2 minutes on 123. I've been working with Excel for a week now, and I'd appreciate some help. To recap, I simply want to be able to choose a cell having data, run a Copy macro and have it paste to the cell below- why is this so damn hard? . Thanks for any help. RHR |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write a simple copy-paste macro?
R.H. here is one way,
ActiveCell.Offset(1, 0).Value = ActiveCell.Value -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "R. H. Rosenberg" wrote in message ... I've used 123 for over 20 years - simple, easy to learn and use, but my XP OS doesn't handle it well, so I'm trying to move to Excel. But in Excel I can't even write a simple macro such as: Copy from a cell, move down one space, Paste. It will do this once, but then not continue. If I run it from another cell - just restarts from the original cell. Without further comment, I learned this macro in 2 minutes on 123. I've been working with Excel for a week now, and I'd appreciate some help. To recap, I simply want to be able to choose a cell having data, run a Copy macro and have it paste to the cell below- why is this so damn hard? . Thanks for any help. RHR |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write a simple copy-paste macro?
Hi
If you are creating the macro by switching on the Macro recorder and carrying out the steps, then you need to switch on Relative Referencing at the start. ToolsMacroRecord new MacroOK at this point the floating toolbar with the Stop recording icon should appear. Next to it is an icon in the form of a Grid. Clicking this is a Toggle between Absolute Referencing (which is what you are describing) and Relative Referencing (that you require). Press this toggle before starting your steps. Be sure to use the Stop icon at the end, rather than the "x" to close, otherwise the floating toolbar does not appear next time. If that does happen, after you start recording the next macro, right click on a blank area of the toolbars, and from the Toolbar dropdown, click the Stop Recording bar and it will re-appear. -- Regards Roger Govier "R. H. Rosenberg" wrote in message ... I've used 123 for over 20 years - simple, easy to learn and use, but my XP OS doesn't handle it well, so I'm trying to move to Excel. But in Excel I can't even write a simple macro such as: Copy from a cell, move down one space, Paste. It will do this once, but then not continue. If I run it from another cell - just restarts from the original cell. Without further comment, I learned this macro in 2 minutes on 123. I've been working with Excel for a week now, and I'd appreciate some help. To recap, I simply want to be able to choose a cell having data, run a Copy macro and have it paste to the cell below- why is this so damn hard? . Thanks for any help. RHR |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to write a simple copy-paste macro?
I want to thank those of you who sent suggestions. After significant
further work I did create and ran a "Copy" macro, but it doesn't yet respond to the Ctrl-Shift C command. And, I'm left with a number of test macros which I can't seem top delete except tediously one by one. I programmed Fortran in 1978 on punch cards - I think that was almost easier to comprehend than Excel - of course I was a little younger. I'm now 81, and I'm not spending the rest of my days fooling with Excel macros. I can run Excel programs that don't require macros but otherwise I'll stick with good old 123 and live with the quirks that occur with XP (mainly delays). Thanks again, I do appreciate your efforts. RHR "Roger Govier" wrote in message ... Hi If you are creating the macro by switching on the Macro recorder and carrying out the steps, then you need to switch on Relative Referencing at the start. ToolsMacroRecord new MacroOK at this point the floating toolbar with the Stop recording icon should appear. Next to it is an icon in the form of a Grid. Clicking this is a Toggle between Absolute Referencing (which is what you are describing) and Relative Referencing (that you require). Press this toggle before starting your steps. Be sure to use the Stop icon at the end, rather than the "x" to close, otherwise the floating toolbar does not appear next time. If that does happen, after you start recording the next macro, right click on a blank area of the toolbars, and from the Toolbar dropdown, click the Stop Recording bar and it will re-appear. -- Regards Roger Govier "R. H. Rosenberg" wrote in message ... I've used 123 for over 20 years - simple, easy to learn and use, but my XP OS doesn't handle it well, so I'm trying to move to Excel. But in Excel I can't even write a simple macro such as: Copy from a cell, move down one space, Paste. It will do this once, but then not continue. If I run it from another cell - just restarts from the original cell. Without further comment, I learned this macro in 2 minutes on 123. I've been working with Excel for a week now, and I'd appreciate some help. To recap, I simply want to be able to choose a cell having data, run a Copy macro and have it paste to the cell below- why is this so damn hard? . Thanks for any help. RHR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Copy Paste macro | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |