Search results

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

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...

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

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

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

Thank you RDAngelo Your solution works perfect. Regards, Don

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

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...

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

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...

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...

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...

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...

Thank you p45cal for your help Regards, Don

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...

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...

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

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...

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...

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

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...

thought there could be a solution....

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...

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

Hello vletm Could you help in getting your solution (of table row 'indicator' as seen in the snapshot) work for normal range (without table) in a worksheet? In the normal range (without table), the indicator column would be coloured in Column A. If the current row selection has any value...