ListBox RowSource set to range of in-active sheet - possible?
I am trying to set a listbox RowSource to a range of cells on another,
in-active sheet. Is this possible?
Using this give me the range of the active sheet :
lstAddress.RowSource = "A4:E4"
What needs to be added to make this reference another sheet?
Thanks - Sean
|