Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro Recorder Please
Could someone please provide an explanation to why the macros that I play back do things differently than when I perform the steps manually in record mode? The main difference usually revolves around me deleting columns and then pasting some cell contents... For example: If I delete columns C, D, and E and then paste something in cell N16, 17, and 18...the deletion of the columns works but the info gets pasted into another column such as L16, 17, and 18. Thanks, Hulk -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php...o&userid=14947 View this thread: http://www.excelforum.com/showthread...hreadid=268061 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro Recorder Please
Hulk
Can you post the code? I suspect that the rows you are deleting are being re-indexed during the delete, resulting in the incorrect addressing Nick Hodge "Hulk" wrote: Could someone please provide an explanation to why the macros that I play back do things differently than when I perform the steps manually in record mode? The main difference usually revolves around me deleting columns and then pasting some cell contents... For example: If I delete columns C, D, and E and then paste something in cell N16, 17, and 18...the deletion of the columns works but the info gets pasted into another column such as L16, 17, and 18. Thanks, Hulk -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php...o&userid=14947 View this thread: http://www.excelforum.com/showthread...hreadid=268061 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro Recorder Please
What does the code look like? Please post it. Obviously it needs some changes.
One possibility is to paste before you delete. On Sun, 10 Oct 2004 21:16:33 -0500, Hulk wrote: Could someone please provide an explanation to why the macros that I play back do things differently than when I perform the steps manually in record mode? The main difference usually revolves around me deleting columns and then pasting some cell contents... For example: If I delete columns C, D, and E and then paste something in cell N16, 17, and 18...the deletion of the columns works but the info gets pasted into another column such as L16, 17, and 18. Thanks, Hulk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro recorder | Excel Discussion (Misc queries) | |||
macro recorder question | Excel Programming | |||
Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming |