Hi everyone!
I wrote a VBA code, which is to copy multiple tables from Excel and I paste it in Word, using VBA. I did not change any format of the table, but when I use VBA, the vertical alignment is not neat.
Not neat.PNG
It appears like it has a 'top' vertical alignment, but when I looked at the Table properties, the vertical alignment is center. Thus, I cannot even manually change the vertical alignment to 'center' again, because it is already 'center', it is just not neat.
My VBA code is that I chose a certain range of cells to be copied, then I paste in Word.
However, if I copy the same table from Excel to Word without VBA, it is much more neater with a 'real' center vertical alignment.
Neat.PNG
Does anyone know why this is happening? Thank you so much for the help!
Bookmarks