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...
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?
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...
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...
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...
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...
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...
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:
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 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.
I came across a sample code to create csv file from a selected range as below (hopefully this could be useful for others):
I would like to make this work where it generates a csv file only for the filtered data list.
Could you please help...
In one of my earlier post, regarding highlighting Table's current row selection was solved.
You can refer the above link for the working of a table's current row...