Hi all,
I am working on a spreadsheet with 14 columns. When i search for a value in the first column and try to populate a list box with the matching value and row. I am getting the following error
Run-Time Error '380': Could not set the list property. invalid property value.
The code i am using for populating the list box is shown.
I was able to utilize the code for a 10 column spreadsheet. I updated it for use on the 14 column spreadsheet but i am stuck. The code stops on the line with
.List(.ListCount - 1, 10) = c.Offset(0, 10).Value.
Any ideas what i am doing wrong?
Thank you for all your help
Bookmarks