^ For a discussion of Relative Recording, see "A Possible Solution: Using Relative References When Recording," p.25,in Chapter 1. Sub Macro3()

Macro3 Macro

Macro recorded 10/29/2003 by Bill Jelen Move one address into database format.

Then move the cell pointer to the start of the next address. Keyboard Shortcut: Ctrl+Shift+A Selection.Copy

ActiveCell.Offset(0, l).Range("A1").Select ActiveSheet.Paste

ActiveCell.Offset(1, -l).Range("A1").Select Application.CutCopyMode = False Selection.Copy

ActiveCell.Offset(-1, 2).Range("A1").Select ActiveSheet.Paste

ActiveCell.Offset(2, -2).Range("A1").Select Application.CutCopyMode = False Selection.Copy

ActiveCell.Offset(-2, 3).Range("A1").Select ActiveSheet.Paste

ActiveCell.Offset(4, -3).Range("A1").Select End Sub

0 0

Post a comment