View Single Post
 
Old 01-14-2021, 01:51 AM
kyotokisses kyotokisses is offline Windows 10 Office 2010
Novice
 
Join Date: Apr 2020
Posts: 11
kyotokisses is on a distinguished road
Default

Thanks Macropod. The tables are not very different in that there is only 1 additional column that I want to omit from the Word doc but the number of rows is subject to change. I tried one of the macros you created for another user, and got an error as below.

2.PNG

1.PNG

Any idea what I'm doing wrongly?

To add on, I've split the whole table into 2, with the rent table being the last item on the first table. I'm thinking it might be the lock feature that I'm using that's causing this issue but unfortunately I'm very very new at VBA and unable to write complex macros to make the info export and row addition work together.
Reply With Quote