Excel issue - COUNTIF

[geezer]

First thing I do when training any MS Excel course is to get all the delegates to check their regional settings - make sure it is set to English (South Africa) & then change the short date from yy/MM/dd to dd MMM yyyy, then get them to change the decimal character for both numbers & currency from the comma to the decimal point, the digit grouping symbol from a comma to a space (if applicable), and also make sure that the list separator is set to the comma & NOT the semi-colon.

View attachment 1785403

View attachment 1785405

View attachment 1785406

That's what I always do when setting up a computer after a new Windows install.

 

[Toxic T]

@Ivan Leon I need your expert advise please.

I created a macro on Excel that used to work perfectly until about a week or 2 ago.

I went into the VBA and noticed that when I apply an autofilter (Selection.Autofilter), it restarts the subroutine.

If I go to point where the subroutine stopped in VBA and press F5, it runs as normal.

Is there any advise you can provide?

 

[HAL 9000]

@Ivan Leon I need your expert advise please.

I created a macro on Excel that used to work perfectly until about a week or 2 ago.

I went into the VBA and noticed that when I apply an autofilter (Selection.Autofilter), it restarts the subroutine.

If I go to point where the subroutine stopped in VBA and press F5, it runs as normal.

Is there any advise you can provide?

It may be that a recent update to either Windows or MS Office (Excel) may have changed something that the subroutine is referring to when doing the AutoFilter (like formatting or punctuation). Check the code & see if you can isolate the error & correct it.

 

[dabean]

@Ivan Leon I need your expert advise please.

I created a macro on Excel that used to work perfectly until about a week or 2 ago.

I went into the VBA and noticed that when I apply an autofilter (Selection.Autofilter), it restarts the subroutine.

If I go to point where the subroutine stopped in VBA and press F5, it runs as normal.

Is there any advise you can provide?

It might be triggering an event.

Try something like this:

Application.EnableEvents = False
Selection.Autofilter
Application.EnableEvents = True