is it possible to bind a NamedRange spanning over multiple columns to a collection or datatable having several columns or properties.

From what I read till now the binding of a namedrange is only to 1 field.

NamedRange.Databinding.Add("Value2",datasource,"1column")

can anyone help?

Thank you for the reply. I already know this option. I mean to loop through all records and do whatever to set the Value2 property of the namedrange.

In fact I am seeking a binding solution that will be faster and will reflect the changes automatically to the datatable or collection. In your example you are just displaying the data but what if you wanted to give the user the choice of editing??? you will have to keep track of changes and reflect them on the source....

Hi "sam"

I believe a NamedRange can be bound only to a single field (column), yes. You can use a ListObject to bind to multiple columns.

I'm having difficulty envisioning a scenario where you'd want to bind to multiple columns. But theoretically you should be able to change the binding of a NamedRange to a different column? I think that would be your only possibility, outside of not using automatic binding at all.