That's hacky and prone to bugs. One cleaner approach is to replace the
datagrid control with an excel control and re-work your code to manipulate
the valid excel object. Microsoft offers their free excel controls (office
web components) for just that purpose on the microsoft office download site.
The OWC works with either windows or web forms by the way.
--
Regards,
Alvin Bruney [MVP ASP.NET]
[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @
http://www.lulu.com/owc
----------------------------------------------------------
"Marty" <ma********@absu.accenture.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Is there a way to manually copy an excel cell range to a datagrid
column? I am unable to select the whole column and selecting multiple
whole records does not work. Thx.