Good Day!
I just want a little help on my problem. I have a range as below that I want to copy to msword. Only the selected range of columns B, C, J, K. But when it reaches to msword it copies also D, E, F, G, H, I:
How to make it to only copy the selected range which is column B, C, J, K?![]()
Application.Union(range("B2:C" & ArrayCounter + 2), range("J2:K" & ArrayCounter + 2)).Select Selection.Copy objWord.Selection.PasteExcelTable False, False, False
Thank you for helping.
Bookmarks