I'm tryinig to pull Word table cells(2,2) thru cells(5,2) into Excel range(B10:B15). I've taken a previous standard macro I found in multiple locations on the Internet and edited to the best of my VBA-Newbie ability. Now the problem is this:
It cycles through the 4 word cells I want, but copies that data 4 times in the same cell then does the same to the next 5 cells in range(B10:B15), all having the same last cell value (i.e. 111). This is a sample of the Word table figures I"m try to pull.
Title |
Title |
Title |
Title |
a |
247 |
percent a |
desc a |
b |
8 |
percent b |
desc b |
c |
5474 |
percent c |
desc c |
d |
111 |
percent d |
desc d |
My code:
Bookmarks