Easy Type Mismatch Issue

Hola Gurus,

For some reason this keep throwing a 'type mismatch' when run in column AB... but when run in AA it's fine!!! Can someone please guide me?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Should be "RowCtr". and really, RowCtr & LR should both be declared as Long.

Please Login or Register  to view this content.

Other than that, will need to look at your worksheet to say for sure what's causing the issue.

Ah you found my typo!

Thank you for your response. I attached a file(a small version) for testing to show you what I mean...

Column B works with your version and my version, but column D does not! Column D does have a formula... but I tested with values only and still had the issue.

Any ideas?

That's because of #Value errors in your column D.

Use =IFERROR(Your Calc,"") to get rid of it and code will work fine.

I tested that and it works...

Is there any way to make the macro ignore the #VALUE! cells? I would like to avoid changing the formulas as I will need to do this weekly and the formulas are exported with the data.

What should happen if cell contains error?
Just ignore it?

Yea... I added an Error Handler to it so I'm good.

Thanks!