I am struggling to write the code to define the data in a given row, in this case row 4, as a named range. Once I have the named range, I can use it to populate a combobox on a form using: UserForm1.ComboBox1.RowSource = "TheRange"
I've researched trying to transpose it. I definitely want to avoid copying and pasting the data into a worksheet.
Any help greatly appreciated!