View Single Post
 
Old 06-07-2010, 04:02 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Most people's first experience with VBA can be compared either to opening Pandora's box, or to Alice's trip down the rabbit hole. In either case, I hope the experience turns out positive for you.

What is VBA?

Where do I run this code?

So basically:

- Use "Alt-F11"

- Create a module "Insert > Module"

- Paste the code in the module.

- Go to your worksheet and select the cell with the intended sheet name.

- Run the code.

Good Luck!
Reply With Quote