cntr

Evening, I have a combobox where i would like to show a msgbox when the entries become only 2 left. Please can you advise Private Sub UserForm_Initialize()Dim cl As Range Dim rng As Range Dim lstrw As Long Dim lastrow As Long Dim Lastrowa As Long Dim cntr As Integer...

Hi, I have a worksheet which is sorted from old to new date in column A where A9 is 02/01/2017 & A978 is 07/10/2019 In column B are the customers names. A code collects all the names column B & sorts them into an A-Z order, this takes place in column L I have a userform where a field called...

Hi. On my useform i select a name from a list & then press the transfer button. Now on my worksheet todays date has been entered in the cell which refers to the name i had selected on the userform. Normally the list on the userform has many names so this is a first for me because now there are...

I have a function that identifies and then will either hide or unhide hidden columns. However, I'm at a loss how to maintain the array between times it's called. For example, immediately below is an example of the processes I would perform. AutoFilter table arr_col_unHide 'Identify/unhide...

I have used the following macro in the past to identify and delete subtotals = zero and their associated ranges. I'm subtotaling on changes in column q with values in column U. I am receiving a Run-time error '13': Type Mismatch and I do not know how to resolve this issue. Thanks for any...

Hello, Looking for some help would would save lots of time and manual labor. It is a basic index match with 3 criteria; as well as obtaining the MAX value of the index. So; the raw data looks like such. <tbody> SHEET 1 A B C D E 1 Group Business Control Risk1 Risk2 2 ABC...