slaycock I believe I have led you off path. I am writing an excel macro to work within word, not a word macro to work through excel.
The macro will be ran from excel, here is what it does.
1. user selects file to open
2. searches column A of excel to find cell with text "avg" in it and then matches column e with that row and selects the appropriate cell
3. copy the cell
4.open word document
Now what I want to do is paste the copied cell into the first blank cell of column 3 in my table in the word document.
Does this make sense?
I am writing the macro from excel, not from word
|