Type mismatch error

[welchs101]

I have a macro (see enclosed). Basically, on sheet1 in col-G i list the sheets thare in the file. For each sheet in the file i am going to find the date col and then starting at the bottom of the col work my way up looking for similar month and year.

problem is that it goes through the for/next the first time abut when it gets to the 2nd time it has a problem.

any ideas..........error code is type mismatch..........but i don know

[welchs101]

ok, figured it out.

On the 3rd page "Test2" the last row is not a date but rather its "AVG". So when i do this

Month("Avg") it has a type mismatch error.

question: I want to allow this error to occur but what is teh best way to test for it.....i know its something like onerror

[Marcol]

I have no idea what you are trying to do

But the error occurs here when you are trying to evaluate "avg" as a date

Please Login or Register  to view this content.

Try this instead.

Please Login or Register  to view this content.

Hope this helps.

[welchs101]

Just what i needed..........thanks. I was looking up info on error statements and which one i wanted.

This is much easier!!!!!!!!!!!!!!! thanks.