Run Time error 13 : Type Mismatch

Hi Everyone,

I am facing a compatibility issue in excel 2007 & 2010.

The following piece of code works fine in Excel 2007 & 2003.

Please Login or Register  to view this content.

But when i run this code in Excel 2010 Its throwing the below error in this line " StartRow = range.Cells(1, 2) "

Run Time error 13 : Type Mismatch

Am I missing anything here. Please suggest. Thank you in advance

I'd suggest changing your variable names. Not a good idea to use variables like range as it can cause conflicts with the vba term. Use rng instead or MyRange or something.

Thank you for the response. I tried 'rangee'. one with extra 'e'

StartRow = rangee.Cells(1, 2). But still the same issue.

Hi Norie,

I have declared StartRow As Integer.

rangee.Cells(1,2) has a number

Norie, I stepped out of my office. I am accessing the forum from mobile. Will upload once I am back to the seat. Thank you much.