|I'll try one more time.|
Let me ask my question in a different way:
The MATCH function returns a number. How does that number help you determine whether the paste column is K or Y or AB?
Does 11 mean Column K, 25 mean Column Y, 28 mean Column AB, etc?
Keep in mind that I can't see your spreadsheet from where I'm sitting nor can I read your mind. You said:
"I need to change this instruction to use the figure generated in a static cell to determine the position of the paste, instead of "K1", 10, or 20, or 50.
The figure is generated using a MATCH formula."
OK, so let's say the MATCH function returned 50. Does that mean Column 50 i.e. Column AX?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.