Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
Hi everyone. I have a list box that I use code to set the range it gets its values from. It's basically a list of sheets in the workbook...which can change. When the workbook opens, it gets a list of sheet names and populates a range, then it names that range myRng. I have the list box set to myRng...but it seems I have to delete that property and then put it back in for it to work...does anyone know how to do this through code?
Thanks,
Dave
Thanks,
Dave