Macro with relative address problem XSL 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Basically I want to (and did at one time) create a macro that edits a
number (zip code), inserts a leading zero then moves down one cell.

Cell Contents
A1 1234
A2 2345
A3 3456

With the cursor on A1 my steps are:

Tools\Macro\Record a New Macro\z
On Stop Recording Toolbar depress Relative Address, then
Edit
Home
'0
enter
Down
Click Stop recoding


Since the cursor is on a A2, Pressing CTRL+z will make the contents
01234, not the desired 02345.

I've tried different combinations of when to depress the relative
address button with no success. And double clicking the cell instead
of F2.

Any help giving me a solution or pointing to one appreciated.

--
Dave
Central Mass. USA

To email: Replace
mailinator.com with email.com
.

Relevant Pages

  • Re: JTable/TableModel undoing
    ... similar and related edits (e.g. collapsing multiple single character deletions into a "word deleted" edit). ... Either a cell was updated or it wasn't. ... E.g. what should happen if the user has edited some change in a cell, the change has not been applied to the model, but the user invokes undo? ... Here it seems to me that the JTable should have delivered change notifications for the text edits to the undo manager. ...
    (comp.lang.java.programmer)
  • Re: Validation is not working
    ... the change event only fires when someone edits a cell. ... Private Sub Worksheet_Change ... MsgBox "That Entry is NOT ALLOWED!" ...
    (microsoft.public.excel.programming)
  • Re: Macro Help (Uppercase multiple ranges?)
    ... Can you tell me what further edits I need to make? ... How do I edit this Code to properly work on multiple Ranges ... Macro to Change All Text in a Range to Uppercase Letters ... ' Loop to cycle through each cell in the specified range. ...
    (microsoft.public.excel.misc)
  • Re: Print Preview Renaming BOM Colum?
    ... after making all the edits you want, ... Properties and uncheck automatic update of BOM ... Default/QTY I would like it to just say QTY. ... I have tried editing the cell, and then saving it, but it still ...
    (comp.cad.solidworks)
  • Re: I cannot fit all of my information in a single cell...`
    ... If you are entering through a form, ... check the edits on each control on your form (as you can further define the ... > characters in that cell. ...
    (microsoft.public.access.gettingstarted)