Am not suggesting that the above code is suitable for a professional application However sometimes we are writing macros just to automate a onetime mundane task

Without a macro, I would have done a lot of copying and pasting manually. Now, with the preceding recorded macro, I could place the cell pointer on a name in Column A and hit Ctrl+Shift+A. That one address would be copied into three columns and the cell pointer would move to the start of the next address (see Figure 5.13).

Figure 5.13

After running the macro once,one address is moved into the proper format and the cell pointer is positioned to run the macro again.

0 0

Post a comment