VBA - Count filtered rows in the table

[DocAElstein]

…
thanks for trying , thanks for your time

Sure no problem.

---

It's too complicated, too much green color in your code - I understand nothing!
I have decided not to use vba ever again…

That is a bit like me with PQ I suppose. I would like to understand it, but I doubt I will ever get the time.

Also I think with VBA it makes a very big difference if your native language is English or not. It is very wordy , but only in English. Half the code speaks for itself. It’s very visual in a basic sort of way….
I expect that if VBA was in other languages and not just English, then the main VBA forums would not have half the traffic they do. Anyone whose native language is English should be able to pick up VBA quite quickly

As for the ' green comments, there is a couple of things you can do to get rid of them.
Hide comments,
_ For one thing, there is loads of room to the right, so you can………………… ----->

                                                                 
                                                                                 ---->                                                          ……………………………………………………………………………………………………………………………………….. put comments way way out to the right so you don’t have to see them all the time. It’s great for hiding links to good references and hiding links to good porno sites

It looks like there are about 1023 characters https://www.excelfox.com/forum/showt...ll=1#post10948 So you have plenty of space to put lots of stuff in

Remove comments
_ The other thing you can do to get rid of them is a search and replace with wild cards,

Before:

Highlight the code you want to clean up and find the Search thing
, , or , or use keys Ctrl+F ( when in VB Editor )


You need to da a search with wild card with these two characters, ( no space in between) '*


Then you leave the replace bar empty and do a replace all

'*	<------ Find
	<--- Replace ( leave empty )

Then they are gone.


( Only very rarely that can give a problem because sometimes a ' is used in coding. So you might accidently lose a bit of coding. But that does not happen often. I don’t think I have any ' inside the coding I did for you. )

I would be surprised if removing comments makes a coding easier to understand. Many people just don't like having them there, often people who already know VBA and/ or the particular coding very well. But they are easy to get rid of if you don't like to see them. Just personal preference, but they are easier to get rid of

VBA cannot currently read your mind and write a code for you. But probably ChatGPT & co. will come close to doing all that, or one way or another it will get rid of most of us. Newer versions of Windows, Office, and most Microsoft will all become just something like Chat GPT and artificial intelligence. We have no long term future, other than to become self sufficient with earlier versions and have nothing to do with Microsoft and any of their software from the last 10 - 15 years

Currently you would also need yourself to download a file and open it and use it, unless you can get someone else to do that for you. I can't do that over the internet, I figured you could / would do that at least. But hey, why be dull and conventional! Do / don't do wot you want, seriously – there is too many people in forums acting like teachers in a nursery school from the 1950’s. They’re too weak or stupid to cope with real hard life I expect.

---

I have decided not to use vba ever again..

You should never say never to anything, JIMO … or…well perhaps there is… maybe say never to anal sex. I would never do that, not even if I was Gay. Poking my cock into shit is the worst thing I can think of, ( apart from maybe trying to Learn PQ, that might be almost as bad. Although if I had to choose between poking my cock into shit, or learning PQ, I probably would choose learning PQ. But it would be a close thing! I speak English but I can’t make head or tail of PQ code. I don’t even know how/ where to find the code. I never got a PQ to work even on my Excel 2013 ( https://www.excelfox.com/forum/showt...ll=1#post23219
( https://www.excelfox.com/forum/showt...3214#post23214 ) ) )

You don’t have to understand all of a VBA coding to use it, - most peole using a VBA macro don't understand it.
But I agree it’s best not to use coding you don’t understand. But that is just personalö preferrance. I personally only ever started learning because I needed it for some important personal projects, and I don’t like using things that I don’t understand.

---

---

I started doing some further notes earlier today, https://www.excelfox.com/forum/showt...ll=1#post23247
You probably aren’t interested, but I will probably finish them anyway, maybe in a day or two. sometime for my own reference. There is some amazing stuff in those codes that only I know about because I discovered them. It still is a long complicated coding, but without the amazing stuff I discovered , it would be even more complicated and probably 3- 4 time longer.
I don’t know all VBA. No one can know it all, it is just too big. You could not learn it all even if you did nothing else for your whole life. I only know a very small part of it. But some of what I know I know better than anyone. I got a big cock as well. (But I don’t stick it in peoples arse). If my YouTube / VBA / forum career does not take off, I can earn lots of money as a Gigolo instead.