Hello to all. I am having trouble pasting a value. I am doing this with code. I can get a value copied to the clipboard but I can't get the proper cell to paste it in. I can use vlookup to find the proper rowe then set the correct collum, but the problem is that the vlookup value changes. The value to lookup is a range name "FndName" (inputted from a userform text box). The lookup range is "worksheet!D7:38". collum to paste to is "G".
Hope this makes sense.
All help is appreciated
phil