VBA countif within a dynamic column

Good morning,

I have a short test vba, where I am counting how often number 3 is shown in column "A".

I would like to replace the range with the static "A1000" and exchange it to the last row
with a value.

I tried to implement

Please Login or Register  to view this content.

but without success.

Is there an easy way to approach this target?

Thank you very much,

Mike

Please Login or Register  to view this content.

works perfectly, thank you so much!!!