VBA is not working properly when Filters are activated

I've run this code and the results on my worksheet are identical regardless of whether the filters are activated or not.

So the problem is likely not in this code. I think you need to put your own sheet up and tell us exactly what you do to recreate the problem.

Hi Croweater,

enclosed is a spreadsheet with the VBA.

So the issue only occurring when below criterias are meeting:

Filters are activated and when Group "+" mode is switched on.

when these criterias are activated, data located on columns ranged A:F (which is hidden by +) is not copied on down row.

Filter function is necessary to be used when there are +100s of tasks and Group + is permanently used for A:F as there are just numbering located.

any feedback is highly appreciated.

Thanks,
N

Try copying each cell individually...something like this;

Please Login or Register  to view this content.

Hi Croweater,

its weird thing that this is happening. unfortunately this also has not fixed the issue.

maybe there could be another alternative of copying selected row one row down? where some areas of the columns could be Grouped by + and hidden, or even password protected?

Any support is highly appreciated guys.

it is very important for me to fix this issue.

Thanks so much in advance.

Regards,
N

Filtering does some weird things. See for example https://stackoverflow.com/questions/...-filtered-data

Best thing to do is in code you can unfilter, do your updates and then re-filter

Yes, it is weird, especially when that code worked fine for me.

If you put your worksheet up with the changes you made, that doesn't work, I'll have another look.