How to do - MS SQL C# Excel Access: VB.NET and Excel

Showing posts with label VB.NET and Excel. Show all posts

Friday, 24 February 2012

VB.Net Excel - How to Fix Error Error - "Select method of Range class failed"

osheet.Range("A3", "A3").Select()
oexcel.ActiveWindow.FreezePanes = True

Replace with

osheet.Select()
osheet.Range("A3", "A3").Select()
oexcel.ActiveWindow.FreezePanes = True