Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with excel!
This one line errors out.
lastrow = nfrcws.Range("A65536").End(excel.XlDirection.xlUp) .Row + 1 vb.net gives this error below. Im using vb.net with excel 2000 An unhandled exception of type 'System.MissingMemberException' occurred in microsoft.visualbasic.dll Additional information: Public member 'XlDirection' on type 'ApplicationClass' not found. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with excel!
Pat Lenahan wrote:
This one line errors out. lastrow = nfrcws.Range("A65536").End(excel.XlDirection.xlUp) .Row + 1 vb.net gives this error below. Im using vb.net with excel 2000 An unhandled exception of type 'System.MissingMemberException' occurred in microsoft.visualbasic.dll Additional information: Public member 'XlDirection' on type 'ApplicationClass' not found. I don't speak VB.Net but it looks like it may be a bug in the .Net object model. You could try substituting the appropriate constant value lastrow = nfrcws.Range("A65536").End(-4162).Row + 1 and adding a comment to indicate that you mean xlUp. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|