Merging specific cells via VBA macro
I posted the following query in the Tables area, but then saw that most VBA questions were here. Please forgive the double-posting.
I need help with a macro to merge a specified set of cells in a table in a Word 2007 document. My goal is to use code to avoid having to tell hundreds of users which cells to select and merge in a large table, since asking them to do that would inevitably lead to problems. What I've determined so far is that I can't record such a macro, because I can't select the table cells once the macro recorder is active. Once the cells are merged, I want to enter and format text, also using the macro (since it will always say exactly the same thing, to meet regulatory requirements).
As an example, I'd like a macro that will:
Merge the cells from row 32, column 18 through row 38, column 25
Enter the text "Approved Document" in the merged cell and format it as bold and red.
Any and all help will be greatly appreciated.
|