>I'd like to record a macro in Excel which will do the following:
> Copy the contents of the current cell
> Paste that into the cell one row down and one column to the left
> Remove the original row.
>
>Now, I know about recording macros -- but when I record a macro to do this, it records the absolute address of the cells I was on when recording, rather than using relative addressing to the current cell.
>
>Any suggestion?
>
>(Note: OK, this isn't really VFP at all, no VFP involved, just an Excel question)
http://support.microsoft.com/kb/213740
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up