I have a userform that has a couple text boxes and a spreadsheet object (or 'web object'... i got it from 'Additional Controls' in the tools menu). The text boxes send data to a worksheet elsewhere with advanced filters set up. All I want to do is copy the range ("d8:f100") of filter results to the spreadsheet object on the userform.
Really simple.... but I don't know how to do it. Everything I've tried so far has either pasted onto the worksheet itself or not worked. The use can paste manually of course but I want it to happen automatically.
Anyone know?
cheers
Andrew
Bookmarks