Hi All,
I've run into exactly the same problem in the linked post:
http://www.mrexcel.com/forum/showthread.php?t=499431
But I confess to insufficient VBA "chops" to follow the solution proposed. My current range is something like:
OFFSET($A$1,0,0,$C$1,1) where the length varies depending on the value of C1. (basically, C1 tells me how many elements of the list I want in my listbox)
I'd love to "convert" as mentioned in the linked post, and I assume it means something like looping through the range where the list resides and adding elements to an array or range, but not quite sure how to proceed.
Any pointers much appreciated
I've run into exactly the same problem in the linked post:
http://www.mrexcel.com/forum/showthread.php?t=499431
But I confess to insufficient VBA "chops" to follow the solution proposed. My current range is something like:
OFFSET($A$1,0,0,$C$1,1) where the length varies depending on the value of C1. (basically, C1 tells me how many elements of the list I want in my listbox)
I'd love to "convert" as mentioned in the linked post, and I assume it means something like looping through the range where the list resides and adding elements to an array or range, but not quite sure how to proceed.
Any pointers much appreciated
