I am using a listbox in sheet2, I want to refernce a range in sheet1,
have the following statement:

Private Sub ListBox1_Click()

ListBox1.ListFillRange = Worksheets("Sheet1").Range("A4:A14").Address

End Sub


For some reason it is not showing any values. Anyone know why?
Thanks

--
Message posted from http://www.ExcelForum.com