Hi,

I need help with the following problem...

On the formula bar in Excel there is the Name Box that displays the cell name you are currently in. If you have a range of data...say A1:A10 highlighted, and you click in this name box you can give the selected range a name...say "DataList01". When you hit enter that will store the name in the dropdown list in the next to the Name Box field.

If you then select another cell...say B1 and click Data on the toolbar, then click Validation, you will be given a couple of options. If you set Allow = List and the Source = "DataList01", the cell B2 will have a dropdown list with all the elements from the range A1:A10 that you called "DataList01".

As you know, you can select a range of cells in Excel from VB, but how do give the range you selected a Name using a VB program. I have the correct code to select the range, and if I name the range in Excel first then run my VB program, it works.

Any help on this would be great - thanks