Read a named range into an array

Hi

You probably don't need to get the column reference, as there are easy ways to find the position once you have made a selection.

Bit hard without an example file to know your structure, but if you have a range called mths then the code below may help

Dim arr As Variant
  arr = Range("mths")
  ActiveSheet.ListBox1.List = WorksheetFunction.Transpose(arr)

If you need more guidance, then build an example file, put it up onto the post, and you will probably get more detailed code to suit your situation.


HTH

rylo

You packed several things new to me in that short space; I am looking forward to experimenting with them!

I am still tooling with lengthy for/next structures with offsets as I could not recall the relationship between a named range and an array, which gives you a rough idea how far away I was from what you are showing me...