Using Range.clearcontents causing type mismatch error in code

Hi all,

I have a routine that uses two subs in vba to run through some iterations in excel. the code is working great but when I added a line to clear a range where a table is built each time we run the routine, I get Error: type mismatch.

FYI: the second sub "System_Analysis" is what is initially ran and inside of it, the sub "Golf" is invoked. Sorry if the order is confusing.

Please Login or Register  to view this content.

When I step through the code, the error happens after I call 'Golf' and return to system analysis to execute the next line. after reading online I think it is because the range is multiple cells and my next line sets a value for a single cell. Please help this is driving me crazy. again the code works like a charm without the .clearcontents line which is really confusing me.

Thanks and I really appreciate any help,
Capt

Thanks for the quick response.

no it clears the range just fine and finishes the sub Golf no problem. its when the code returns to System_Analysis on the very next line after Call Golf that the error occurs on.

Norie, really thank you for looking at this. I have found the problem and fixed it. I was clearing the table everytime golf was called instead of clearing the table once at the beginning of System_Analysis. that put blanks on fields that were used in calculations so it was throwing the error. I am sorry to have wasted your time though your reply did make me see what I was doing wrong so thank you!!