When autofilter = true, error adding comment to a cell...

[michaeljoeyeager]

Friends, I have a userform that sends information to a row, and one of the fields from the userform gets sent to a comment box. I also have a filter macro that uses autofilter to hide certain rows that the user chooses.

The userform works great unless the filter macro has been used. If the filters are on and I try to add a new row I get an error at this line...

Please Login or Register  to view this content.

But I can then remove the filters and it works again.

Any idea why?

Thanks in advance,

Mike

[bonny24tycoon]

We might need to look at the rest of the code to determine...

[michaeljoeyeager]

Ok here is the code for OKButton Click on the userform. When the filter is not enabled it works fine.

Please Login or Register  to view this content.

And this is the code for the filter macro...

Please Login or Register  to view this content.