Last Row in Column not working

[Guest]

OK, I am stuck. I had the following line of code that was working. My
computer was replaced and I was able to run my program once but now I am
getting a "Type Mismatch 13" on this line of code:

lnglastrow = xlSheet.Cells(xlSheet.Rows.Count, "A").End(xlUp).Row

Anyone have any suggestions?

thanks

Terry

 

[fredg]

OK, I am stuck. I had the following line of code that was working. My
computer was replaced and I was able to run my program once but now I am
getting a "Type Mismatch 13" on this line of code:

lnglastrow = xlSheet.Cells(xlSheet.Rows.Count, "A").End(xlUp).Row

Anyone have any suggestions?

thanks

Terry

Looks as though this is an Excel question.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program
(Excel) you are using. I would suggest you include your Windows and
Office version number in the message.