• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    it highlights the below line on button press (Debug): and when the highlihted line is changed to and button pressed: it gives this error message: Regards, Don
  2. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi p45cal, attahed info. snapshot I am using Windows 10 64 bit. Regards, Don
  3. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi p45cal, I downloaded the post attached file and also the one you attached the last one, both the code in the sub blah gives an error. I changed the code to the new statement in the lastest file you attached and it gives the same error as before. Below 2 snapshots. Are these using...
  4. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi p45cal, I replaced the line with the new one and getting the below message 9On button press and also on F8): Regards, Don
  5. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hello p45cal, Attached file for your reference. Regards, Don
  6. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi p45cal, I am still getting the same error message (as on previous post) on button click. I am using Excel 2016. Regards, Don
  7. I

    Dynamic multiple data filter based on a flexible Array

    Thank you RDAngelo Your solution works perfect. Regards, Don
  8. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Thank you p45cal for taking the time to provide the solution. I am getting the below error message on button click Also, on Worksheet Header, the Sub GetTotals is missing. Could you upload the latest version of your file? Regards, Don
  9. I

    Dynamic multiple data filter based on a flexible Array

    Hello There, I would like to know the actual VBA code which can dynamically filter data based on a flexible array. I have a UserForm with a couple of CheckBoxes. Based on the selection of the CheckBox (checked/unchecked), the value required for the data filter should be added or removed from...
  10. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi @vletm Thank you for your advice. I learned something new today, thank you You are right. I will further debug and analyse your code and put it to best use. :) Regards, Don
  11. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Thank for your reply @vletm I agree, your code works perfect on the visible rows in the worksheet Lines (i.e. unfiltered data) The purpose of attaching my sample workbook was to keep the requirement simple, and to know exactly how one can loop and only read values of the visible rows in a...
  12. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi @vletm Thank you for taking the time to look into my request and to provide the solution. Appreciate your help. The challenge for me is the following. In the actual design there are additinal columns in the Header section and it's other processes are based on all filtered data. Implementing...
  13. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hi @AlanSidman Thank you for your reply and your suggestion. That was also my first thought. However, the user does not want any changes in the worksheet design as this will have an impact on other processes. Therefore, this requirement do it via VBA. Look forward to hearing from you...
  14. I

    Loop through Filtered Data (visible rows), to derive calculated value from 2 columns.

    Hello There, I have 2 worksheets: Header (Section, Total Quanity, Total Amount) Lines (Section, Description, Quantity, Unit Price) I would like to know the following how this can be achieved using VBA code. 1. The common column between 2 worksheets is Column 'Section' 2. For every Header...
  15. I

    Search for occurence of value in a given range of a filtered data (visible rows)

    Thank you p45cal for your help Regards, Don
  16. I

    Search for occurence of value in a given range of a filtered data (visible rows)

    Hello There, I would like to have a Function in VBA which can return the occurence of a given value for the below situation: 1. Data is filtered 2. Search for a value in a given range and count it's occurence (in the filtered area, visible rows only) Parameters for the Function would be: 1...
  17. I

    Excel macro file (Userform Webbrowser) installed on other machine does not work

    Hello There, I have a .xlsm file with a Userform which has a Webbrowser. It works good in my machine. When this file is copied to another machine and the Userform is invoked the Webbrowser does not work nor does it gives any error. I checkd the Userform toolbar and the Webbrowser control was...
  18. I

    Highlight current row selection

    Thank you RDAngelo for taking the time to give me the solution. This works very good. Regards, Don
  19. I

    Highlight current row selection

    Hi RDAngelo Thank you for your reply. I suppose I must have mixed it up with the working of the excel table solution and made it unclear. My apologies. I have attached a sample workbook for your reference and also how this would work. As you mentioned about the pre-defined range: If the range...
  20. I

    Highlight current row selection

    Thank you very much RDAngelo for your VBA code. There is just one catch. When I navigate to a new row, it leaves the trail behind (yellow highlighting and rowheight = 25) in the previous last row clicked. On click to a new row, the previous clicked row should get back it's formatting and...
  21. I

    Generate CSV file from a filtered data list

    Thank you for your reply. The solution stated in my original post does not involve adding a new workbook for making a csv file. It works fine but it does not work for filtered data. The Author's code needs to be adjusted to work for filtered data. Regards, Don
  22. I

    Generate CSV file from a filtered data list

    Hello There, I came across a sample code to create csv file from a selected range as below (hopefully this could be useful for others): http://www.cpearson.com/excel/ImpText.aspx I would like to make this work where it generates a csv file only for the filtered data list. Could you please help...
  23. I

    Highlight Current Table Row Selection (Specific Column/Entire row)

    thought there could be a solution....
  24. I

    Highlight current row selection

    Hello There, In one of my earlier post, regarding highlighting Table's current row selection was solved. https://chandoo.org/forum/threads/highlight-current-table-row-selection-specific-column-entire-row.44783/#post-268229 You can refer the above link for the working of a table's current row...
  25. I

    Highlight Current Table Row Selection (Specific Column/Entire row)

    Hi vletm Your original solution works perfectly fine. Would like to know how this would work without a table as well. Thank you for the Site Rules, I will do a new post. Regards, Don
Top