Results 1 to 10 of 51

Thread: VBA - Count filtered rows in the table

Threaded View

sandy666 VBA - Count filtered rows in... 08-20-2023, 05:23 AM
DocAElstein Hi there :) I am not 100%... 08-21-2023, 12:38 AM
sandy666 sure, here is ... 08-21-2023, 12:50 AM
DocAElstein I don’t see any Excel Filters... 08-21-2023, 10:20 AM
sandy666 there is no excel filter , it... 08-21-2023, 12:05 PM
DocAElstein OK, I understand a bit better... 08-21-2023, 02:42 PM
sandy666 sure, I can tell you but you... 08-21-2023, 08:12 PM
DocAElstein (Using Excel 2013). I think I... 08-21-2023, 11:40 PM
sandy666 https://i.postimg.cc/RZV2Fmps/... 08-22-2023, 03:46 AM
DocAElstein As far as I am aware, nothing... 08-22-2023, 11:45 AM
sandy666 if you change filter values... 08-22-2023, 12:14 PM
DocAElstein OK, I will have another think... 08-22-2023, 12:33 PM
sandy666 this is a big sunflowers... 08-22-2023, 01:01 PM
DocAElstein That does not seem to work... 08-23-2023, 12:21 AM
DocAElstein So here is the next VBA... 08-23-2023, 12:25 AM
sandy666 ok, thanks. I'll test it if... 08-23-2023, 01:16 AM
DocAElstein In newer Office versions... 08-23-2023, 10:25 AM
DocAElstein You can put anything there ,... 08-23-2023, 10:32 AM
sandy666 thanks for tips but I really... 08-23-2023, 10:52 AM
DocAElstein It looks like an Excel... 08-23-2023, 11:36 AM
sandy666 you used it in the first... 08-23-2023, 11:59 AM
DocAElstein ?? That is strange.... 08-23-2023, 12:41 PM
DocAElstein I have no idea at all what... 08-23-2023, 11:20 AM
sandy666 can you define encoding UTF... 08-23-2023, 11:29 AM
DocAElstein No I can't define it. I have... 08-23-2023, 11:50 AM
sandy666 this is very good format I... 08-23-2023, 11:55 AM
sandy666 maybe this is it... 08-23-2023, 01:11 PM
DocAElstein No. that is a VBA built in... 08-23-2023, 01:47 PM
sandy666 it looks like you say that by... 08-23-2023, 02:04 PM
DocAElstein No. Microsoft do not let us... 08-23-2023, 02:37 PM
DocAElstein I have a quick question on... 08-23-2023, 03:15 PM
sandy666 here is some results ... 08-23-2023, 06:35 PM
DocAElstein OK, so answer is like ... 08-23-2023, 06:46 PM
sandy666 filters filtering columns but... 08-23-2023, 07:01 PM
DocAElstein Yep, I guessed that bit right... 08-23-2023, 07:24 PM
sandy666 Take more pics from your... 08-23-2023, 07:46 PM
DocAElstein Hallo I am getting some... 08-24-2023, 01:48 PM
sandy666 total = Table.RowCount(TPH),... 08-24-2023, 06:13 PM
DocAElstein I assume you are trying to... 08-24-2023, 06:23 PM
sandy666 it should be a proper result... 08-24-2023, 07:23 PM
DocAElstein I don't think so, still does... 08-24-2023, 07:39 PM
sandy666 remember to take a pictures :) 08-24-2023, 07:41 PM
sandy666 I need to rewire my brain... 08-24-2023, 08:24 PM
DocAElstein I can't take my camera,... 08-24-2023, 09:15 PM
sandy666 here is table from csv (100... 08-25-2023, 04:19 AM
DocAElstein I don’t know anything about... 08-25-2023, 11:57 AM
sandy666 CF - conditional formatting... 08-25-2023, 12:54 PM
DocAElstein At the moment I am mostly... 08-25-2023, 01:51 PM
sandy666 It's too complicated, too... 08-25-2023, 08:05 PM
DocAElstein Sure no problem. :) ... 08-26-2023, 12:15 AM
DocAElstein Here is another, forth, ... 08-26-2023, 09:35 PM
Previous Post Previous Post   Next Post Next Post
  1. #13
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    240
    Rep Power
    8
    can you define encoding UTF 65001 in VBA ?

    if it will be a problem don't worry too much about it
    Last edited by sandy666; 08-23-2023 at 11:31 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Replies: 101
    Last Post: 06-11-2020, 02:01 PM
  2. Delete Filtered Rows Excluding The Header
    By xander1981 in forum Excel Help
    Replies: 5
    Last Post: 04-01-2014, 11:44 PM
  3. Replies: 1
    Last Post: 07-30-2013, 11:08 PM
  4. Lookup and Count Using Pivot Table
    By RobExcel in forum Excel Help
    Replies: 2
    Last Post: 12-21-2012, 11:08 AM
  5. Unique Count on a Filtered Range
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 04:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •