Unzip the attachment and put it in the desktop (or elsewhere).
Open the workbook and drag it into the VBA project.
For the example you posted, select A1:D1, and in the Names box (left of the formula bar) enter keys
Run macro AlignKeys.
Unzip the attachment and put it in the desktop (or elsewhere).
Open the workbook and drag it into the VBA project.
For the example you posted, select A1:D1, and in the Names box (left of the formula bar) enter keys
Run macro AlignKeys.
Last edited by shg; 09-20-2010 at 06:30 PM. Reason: And now, with the attachment ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks