We seem to be chasing an ever-moving target here. How about posting a copy of both the workbook and the destination document (delete anything sensitive), together with a description of what goes where. You can do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I am sorry for the wild goose chase, I am picking vba up on the go and the more I learn the more I realize what I really want to do with my macro.
At this point, here is what I am trying to accomplish:
Create 3 macros, one for each column of the word table that I am trying to paste into (the -20,5,22).
These macros will be near identical, except for the paste location.
I want to open up a user selected file, copy a cell that is the avg of the data I am analyzing, and paste it into the first blank cell of the correlating column in the word table. Does this make sense? Let me know what other information you would like.
Macropod thank you for bearing with me, I am sure new users can cause frustration for pros like you! Hoping to get better with this skill.