As an example of my dilemma, I simply want a Macro that when executed, copies the contents from the cell immediately above the active cell and moves one cell to the right. I record my macro in cell b2 and I get:

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Terms of Use
Excel is a registered trademark of the Microsoft Corporation.MrExcel is a registered trademark of Tickling Keys, Inc.