Hi. I have a userform i have created with text boxes that users will enter information in and select a range of data they want the information to be displayed in using the refedit control. I am trying to figure out how to properly copy the information into the cells. I tried using the Offset function to skip to the next cell over but it counts the whole range as 1 cell then moves to the next cell outside the range i select and places the value there. One of the values the user inputs into the form is a hyperlink. One of the textboxes is meant for a web address as well that i want to create a hyperlink out of with a friendly name. Having trouble on this as well. I get a run-time error '438': Object doesn't support this property or method on the hyperlink line at the bottom of code:
Any help is appreciated. Thanks!
Bookmarks