Run Time error 13 : Type Mismatch

[sugaprasad]

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

[ragulduy]

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.

[sugaprasad]

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

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

[Norie]

How have you declared StartRow and what's in rangee.Cells(1,2)?

[sugaprasad]

Hi Norie,

I have declared StartRow As Integer.

rangee.Cells(1,2) has a number

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[sugaprasad]

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.