Userform insert data on the last row even when autofilter is active

Hi,

I have a series of userforms that add data to various pages. The problem I have experienced is that if there is an active filter on the page and the userform is used, the new data goes to the end of the autofilter rather than the end of the data. This naturally is a big problem.

Is there a simple way without turning off the autofilter to stop this?

Thank you in advance.

There is a userform for each data sheet, but the form can be called from other sheets. The format is similar but not identicle. Autofilter is possible on all sheets.

The code to add data is (although I have 6+ forms for different sheets):

Please Login or Register  to view this content.

Thank you in advance,

JP

Bump no response

That seems to work perfectly when there is no formatting.But when I add it to a page that has a range wih a coloured backgound the next entry goes to the bottom of the formatting rather than the next entry.

Any thoughts?

I think it is to do with the:

'cell must be within the data table

How do you define what the data table is?