MS Word VBA Randomization of Table

Hi Everyone,

A work colleague asked me to help them simplify a task.

They have a multi-page list of contractors that gets posted to our website. The contact information for these contractors is in a two column table in word. My colleague would like to randomize the listing every so often (currently around 50 contractors, but will expand a lot in the future). I found a macro that will randomize a single-page table, but the macro fails if the table runs onto a second page (and it won't randomize multiple tables if I split them, only the first table on page one).

Does anyone think they might be able to modify this code (or replace it) with something that would allow one of the following two possibilities:

1. A continuous, multi-page two-column table to shuffle its cell text.

2. Multiple tables (one table per page) where cells from any table can be shuffled to any other.

If it's relevant, each cell has at least 9 lines of text (meaning 9 times return/enter was pressed)

Please Login or Register  to view this content.

Thank you,

-LM

Hi Macropod (awesome name btw),

After I resolved a few issues with the document I was provided, your code worked like a charm!

For anyone else who stumbles onto this thread, the header row cannot be a merged cell across both columns. Other than that, works great.

Cheers!

-LM