Odd Type Mismatch with variables and the month function.

[NicholasL]

I get a type mismatch on the line where I set "second" = to the month of the next cell. This is particularly odd because the variable "First" is subject to the same method -- the only difference is that I'm using an offset inside the month function. I've checked the cells and they're all listed as "date" for their type -- not sure if that would be an issue but even if it would it shouldn't be.

Thoughts?

Thanks, very much.

Please Login or Register  to view this content.

[JapanDave]

What is in those cells?

And change this line to this,

Please Login or Register  to view this content.

And why are you selecting cells? Do you have a specific reason?

[p24leclerc]

Not sure about the type mismatch as I did not get it on my computer.
But if your goal is to keep only one row per month, then your macro should be modified like this:

Please Login or Register  to view this content.